Statistical Tools in QI Macros for Excel

You don't have to be a statistician to perform statistical analysis on your data.

  • Does the thought of performing complicated statistical analysis intimidate you?
  • Have you struggled with the awkward interface of Excel's Data Analysis Toolpak?

It's Easy to Perform Statistical Analysis using QI Macros:

statistical tests in Excel

  1. Point - Use your cursor to select your data in Excel.
  2. Click - on the QI Macros menu and select Statistical Tools or select the Stat Wizard if you don't know which test to run.
  3. Analyze and Improve - QI Macros will prompt you for the significance level, run the statistical test for you and help with interpreting the results.
ANOVA one-way single factor Excel with QI Macros

The biggest challenge is to ensure you have your data organized correctly. To help, QI Macros loads practice data on your computer in c:Documents\ QI Macros Test Data. Open the file called anova.xls for examples of how to organize your data.

Statistical Tools in QI Macros with links to more detail


Purchase QI Macros SPC Software for Excel through our secure shopping cart or try a free, QI Macros 30-day trial!