Can I Do Statistical Analysis in Excel?

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

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.

The Basics - How to Run a Statistical Test

QI Macros statistical tools work just like most of the charts. You can conduct any statistical test in three easy steps:

  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 prompt you for the significance level (default is .05) and run the statistics test 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

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 should accept or reject my null hypothesis?

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

accept or reject null hypothesis

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

data visualization of statistical analysis

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


Why Choose QI Macros Statistical Software for Excel?

affordable

Affordable

  • Only $279 USD - less with quantity discounts
  • No annual fees
  • Free Technical Support

easy to use

Easy to Use

  • Works Right in Excel
  • Interprets Results for You
  • Accurate Results Without Worry

proven and trusted

Proven and Trusted

  • 100,000 Users in 80 Countries
  • Celebrating 20th Anniversary
  • Five Star CNET Rating - Virus Free