Meta-analysis Made Easy

MIX 2.0

An Introduction to MIX 2.0

Software for meta-analysis in Excel

Meta-analysis Made Easy

MIX 2.0

What is MIX 2.0?

• MIX stands for Meta-analysis In eXcel

• Nifty add-in for meta-analysis in Excel

• Prior versions of MIX were for Excel 2000/2003

• MIX 2.0 is meant for Excel 2007/2010

Meta-analysis Made Easy

MIX 2.0

MIX 2.0 Lite

• MIX 2.0 Lite is meant for learning and teaching about meta-analysis with Excel

• It’s free and contains many datasets from authoritative books on meta-analysis

• Does almost everything that MIX 2.0 Pro can do, but it has no data management facilities

Meta-analysis Made Easy

MIX 2.0

MIX 2.0 Pro

• MIX 2.0 Pro is professional software for meta-analysis in Excel

• Create, edit, and manage your own datasets of binary, continuous, and generic outcome data

• It’s has a unique feature set and is user-friendlyand affordable

Meta-analysis Made Easy

MIX 2.0

Licenses for MIX 2.0 Pro

• MIX 2.0 Lite is free for everyone, but MIX 2.0 Pro requires a license and activation

• MIX 2.0 Pro has 3 main license options

– Personal: $210.00

– Academic: $155.00

– Student: $75.00

• Academic researchers and students without funding can inquire for further discounts

Meta-analysis Made Easy

MIX 2.0

Meta-analysis Made Easy

MIX 2.0

Meta-analysis Made Easy

MIX 2.0

Meta-analysis Made Easy

MIX 2.0

Meta-analysis Made Easy

MIX 2.0

Meta-analysis Made Easy

MIX 2.0

0.015625 0.0625 0.25 1 4 16 64 256 1024

or

Synthesis forest plot

0

0.05

0.1

0.15

0.2

0.25

0.3

0.35

0.4

0.45

0.5

-3.0 -1.0 1.0 3.0

Frac

tio

n

Standardized residual

Histogram

0.3

0.8

1.3

1.8

2.3

2.8

-4 -2 0 2 4 6

pre

cisi

on

log(or)

Heterogeneity funnel plot

Meta-analysis Made Easy

MIX 2.0

1 2 4 8 16

or

Exclusion sensitivity plot

0.3

0.8

1.3

1.8

2.3

2.8

-6 -4 -2 0 2 4 6

pre

cisi

on

log(or)

Selectivity funnel plot0.01 limit

0.05 limit

0.1 limit

0

1

2

3

4

5

6

7

0 0.2 0.4 0.6 0.8 1

or

Weighting schemes

Weighting sensitivity plot

Meta-analysis Made Easy

MIX 2.0

Exploration

Synthesis

Evaluation

Meta-

analysis

What else is different?

Structured approach

• Exploration– Getting in touch with the data set (lots of plots)

• Synthesis– Formally combining study results

• Evaluation– Checking consequences of decisions made along the

way

Meta-analysis Made Easy

MIX 2.0

What’s not so good about MIX?

• It works inside Excel

– So you need Excel…

• It does not…

– Manage reviews

– Do diagnostic meta-analysis

• Some features are under construction

– We try to improve MIX continuously

Meta-analysis Made Easy

MIX 2.0

Other recommended software?

• General statistics software– STATA, StatsDirect

• Dedicated meta-analysis software– RevMan, CMA, MetaWin, Meta-Analyst

• Recommended Bayesian software– WinBUGS, OpenBUGS

• MIX really stands out in terms of usability, graphics, and educational impact

Meta-analysis Made Easy

MIX 2.0

When do you use MIX?

JUST KIDDING!!!

… but MIX is a great tool…

- For scientific meta-analysis- To produce professional statistics and graphs

- For learning and teaching about meta-analysis- To make cool graphs for presentations…

Meta-analysis Made Easy

MIX 2.0

That’s all there is to it…

Good luck with your meta-analysis!