Not Sure How to Choose the Right Statistical Test?

QI Macros Stat Wizard is smart enough to select the right test for you.

1. Just select your data


statistics data

2. Select the Stat Wizard


statistics wizard

3. QI Macros does the rest


statistics wizard results

Decision Trees are Cumbersome

If you are like most people, you have a hard time deciding which statistical test to run. Rather than finding your way through a forest of decision trees, like the ones in Minitab®, QI Macros has built the decision tree right into its code!

Since you select your data first when you use QI Macros, it can choose the most likely statistical analysis tests and run them for you. Even better, QI Macros interprets the results for you too!

Use this


statistics wizard

stat wizard results

Not that


minitab decision tree example

Watch QI Macros Stat Wizard in Action

Which statistical test should I run?

How the Statistics Wizard Selects the Right Tests to Run

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
    Descriptive Statistics
    1 Sample t test for Means
  • 2 Columns
    F test for Variances
    t test for Means
    Chi-Square Table or
    Equivalence test
    Regression analysis
  • 3 or More Columns
    ANOVA for Means 
    Levene's Test for Variances 
    Chi-Square Table

1-Column Example

By selecting one column of data, Stat Wizard will run Descriptive Statistics and a 1-sample t Test:

one sample t test data

Descriptive statistics: note p value is > 0.05 so data is normal.

descriptive statistics results

One sample t test: Using Test Mean of 2500 hours you will get:

one sample t test results

 

2-Column Example

By selecting two columns, the Stat Wizard will run an F test, t Test and regression analysis. It may also run an Equivalence test, Chi Square or Fishers Exact test.

two sample t test data

Stat Wizard runs the F Test to evaluate variances.

f test two sample results

Since the F test assumes equal variances, the Stat Wizard runs a t test assuming equal variances.

t test two sample results

Next it runs an Equivalence test for Means

equivalence test for means

Then it runs regression analysis for correlation and fit:

regression analysis

Finally, it reports a summary of the results:

stat wizard 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.

First select your data and then click on QI Macros menu and select Stat Wizard.

example of anova one way data

The Stat Wizard will run ANOVA Single Factor analysis:

anova single factor results

Then run Descriptive Statistics

descriptive statistics example results

Then run Chi-Squared Table to evaluate independence of the variables:

chi square sample results

Then run Levene's Test to evaluate Variances:

Levenes test sample results

Then report a summary of the results:

stat wizard results

Learn More...

Why Choose QI Macros Statistical Software for Excel?

easy to use

Easy to Use

  • Works Right in Excel
  • Interprets p-values for You
  • Accurate No-Worry Results
  • Free Training Anytime

proven and trusted

Proven and Trusted

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

affordable

Affordable

  • Only $349 USD
    Quantity Discounts Available
  • No annual fees
  • Free Technical Support
Data Mining and Analysis
Download Free QI Macros Trial
Buy QI Macros for Excel Now