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
Turns Decision Trees into a One Click 
Statistics Wizard

Decision tree top level

minitab-hypoth-test-decision-tree

Select your data and click Stat Wizard

stat-wizard

Decision tree second level

minitab hypoth testing decision tree second level

Input screen to point to data and define other criteria

minitab criteria screen

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:

1-Column Example

By selecting one column of data, Stat Wizard will use Descriptive Statistics and a 1-sample 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 1-sample Stdev test.

2-Column Example

By selecting two columns, Stat Wizard will use F test, t Test, Chi-square, 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 two-sample t test):


Then run Chi-Squared table for independence to determine if they are related:


Then run regression for correlation and fit:

And then report results:


4-Column Example

By selecting the hardwood concentration data below, the Stat Wizard will run a one-way ANOVA to evaluate the means, Levene's test to evaluate the variances and Chi-Squared table to evaluate independence of the variables:

one way anova data

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 one-way ANOVA:


Then run Chi-Squared 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

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