Can I Do Statistical Analysis in Excel?

Yes...but its easier and more accurate to do it using QI Macros add-in

To Run Statistical Tests using QI Macros

  1. Select your data in Excel.
  2. Click on QI Macros menu and select the test you want. If you are not sure which test, click on the Stat Wizard.
  3. QI Macros will do the math and analysis for you.

Excel's data analysis tools are picky about the way you organize and order your data. If you switch the order of columns, you might get the wrong result. QI Macros mistake proofs the data selection process, helps you select the right test and even interprets the results for you.

What are the types of statistical tests and tools in QI Macros?

Tests of Means
test of means QI Macros

Tests of Variances

test of variances

Tests of Relationships
tests of relationships

And More...
normality test

Special Features in QI Macros to Answer These Questions

QI Macros has unique features that help you every step of the way.

How do I organize my data before I run a statistical test?

It is best to organize your data in columns before running a test. Excel is picky about the order of columns, but QI Macros contains code that mistake proofs the calculations. QI Macros also contains sample data for each test to help you better understand how to organize your data.

Which type of statistical analysis should I run?

QI Macros is the only statistical software that will analyze your data and select the correct statistical tests for you. Just select your data and then select the Stat Wizard. QI Macros will run the possible tests and will display a box with a summary of the results.

Stat Wizard on QI Macros Menu

statistics wizard

Stat Wizard Summary Results

statistical wiard results

What do these numbers mean?
How do I know if I can reject my null hypothesis or not?

Each hypothesis test in QI Macros will tell you whether you should reject the null hypothesis or cannot reject the null hypothesis and why.

accept or reject null hypothesis

Many test results also contain a chart like a values plot to help you visualize the analysis.

anova single factor values plot

Can I define or change the significance level?

Each QI Macros test will prompt you for the significance level (default is .05). The results page will show you the level that was used in the calculations. To change the value, simply edit the cell. The dependent calculations will automatically update.

Significance level prompt

significance level prompt

Change significance level and see the impact

change significance level

Stop Struggling with Statistical Analysis!
Start conducting Statistical Analysis in just minutes.

Download a free 30-day trial. Run Statistical Analysis now!

QI Macros can draw these charts too!