Statistics Wizard for Excel
QI Macros Takes the Guesswork Out of Choosing the Right Test
I've noticed that people often have a hard time deciding what statistics to choose and use. So since QI Macros already know what data you've selected, they can choose the most likely statistical analysis tools and run them for you.
Decision Trees are Cumbersome. Rather than having to think your way through the forest of decision trees like the ones in Minitab®, wouldn't it be great if the decision tree was already coded into the software? In QI Macros, it is!
Minitab's® Forest of Decision Trees 
QI Macros 

Decision tree top level 
Select your data and click Stat Wizard 
Decision tree second level 

Input screen to point to data and define other criteria 
Watch How the Stat Wizards Selects the Right Statistical Tests for You
The Stat Wizard will look at your data to determine if it has 1, 2 or more columns of data. Then, depending on the number of columns and whether the data has decimals or integers, it will run the following statistics:
1Column Example
By selecting one column of data, Stat Wizard will use Descriptive Statistics and a 1sample t Test:
Stat Wizard will give you descriptive statistics (note p value is > 0.05 so data is normal):
Using Test Mean of 2500 hours you will get:
You can also input a Test Stdev to get 1sample Stdev test.
2Column Example
By selecting two columns, Stat Wizard will use F test, t Test, Chisquare, Fisher's Exact test and regression:
Stat Wizard will run the F Test to evaluate variances:
Then run t test to evaluate the means depending on whether the variances are equal or unequal. (Note: the Stat wizard will not run a paired twosample t test):
Then run ChiSquared table for independence to determine if they are related:
Then run regression for correlation and fit:
And then report results:
4Column Example
By selecting the hardwood concentration data below, the Stat Wizard will run a oneway ANOVA to evaluate the means, Levene's test to evaluate the variances and ChiSquared table to evaluate independence of the variables:
Select the data with your mouse and click on QI Macros Menu to choose:
Stat Wizard. The Stat Wizard assumes a significance of 0.05, but you can change this after it has completed.
The Stat Wizard will run the oneway ANOVA:
Then run ChiSquared Table to evaluate independence of the variables:
Then run Levene's Test to evaluate Variances:
Then report the results:
Learn More...
Hypothesis Testing Quick Reference Card
Why Choose QI Macros Statistical Software for Excel?
Affordable
 Only $279 USD  less with quantity discounts
 No annual fees
 Free Technical Support
Easy to Use
 Works Right in Excel
 Interprets Results for You
 Accurate Results Without Worry
Proven and Trusted
 100,000 Users in 80 Countries
 Celebrating 20th Anniversary
 Five Star CNET Rating  Virus Free