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:
- Select your data in Excel.
- Click on QI Macros menu and select the test you want.. If you are not sure which test, click on the Stat Wizard.
- 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
Tests of Variances
Tests of Relationships
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
Stat Wizard Summary Results
What do these numbers mean? How do I know if I should reject my null hypothesis or cannot reject my null hypothesis (accept the null hypothesis)?
Each hypothesis test in QI Macros will tell you whether you should reject the null hypothesis or cannot reject the null hypothesis (accept the null hypothesis) and why.
Many test results also contain a chart like the box and whisker plot to help you visualize the 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
Change significance level and see the impact
Why Choose QI Macros Statistical Software for Excel?
Easy to Use
- Works Right in Excel
- Interprets p-values for You
- Accurate No-Worry Results
- Free Training Anytime
Proven and Trusted
- 100,000 Users in 80 Countries
- Celebrating 20th Anniversary
- Five Star CNET Rating - Virus Free
- Only $329 USD
Quantity Discounts Available
- No annual fees
- Free Technical Support