# Not Sure How to Choose the Right Statistical Test?

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

I've noticed that people often have a hard time deciding what statistical test to run. Since QI Macros already knows what data you've selected, it can choose the most likely statistical analysis tests 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!**

Forest of Decision Trees |
## QI Macros |
---|---|

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

Decision tree second level |
QI Macros analyzes your data and runs: Descriptive Statistics, Anova Single Factor, Chi Square and Levene's test. It also summarizes the results of these tests in one easy to read output screen. |

Input screen to point to data and define other criteria |

### Watch QI Macros Stat Wizard in Action

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 run Descriptive Statistics and a 1-sample t Test:

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

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

### 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.

Stat Wizard runs the F Test to evaluate variances.

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

Next it runs an Equivalence test for Means

Then it runs regression analysis for correlation and fit:

Finally, it reports a summary of the 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.

The Stat Wizard will run ANOVA Single Factor analysis:

Then run Descriptive Statistics

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

Then run Levene's Test to evaluate Variances:

Then report a summary of the results:

### Learn More...

- Statistical Tests run by QI Macros for Excel
- Non Parametric Tests
- List of all wizards available in QI Macros

### Why Choose QI Macros Statistical Software for Excel?

### Affordable

- Only
**$299 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