# You Don't Have to be a Expert to Run an F-Test in Excel

## QI Macros can run an f test and interpret the results for you!

#### Run F-tests using QI Macros:

- Select your data.
- Click on QI Macros menu > Statistical Tools > F & t Tests > F-test.
- QI Macros will do the math and analysis for you.

### f test example using QI Macros add-in for Excel

- Click and drag over your data to select it in Excel:
- Click on the QI Macros Menu > Statistical Tools > F & t Tests, and then select "F-test: Two-sample for Variance":
- QI Macros will prompt for a significance level (default = 0.05):
- QI Macros will perform the F-Test calculations and interpret the results for you:

**QI Macros interprets the f-test results for you**

QI Macros built in code compares the p value to alpha and tells you what that means. In the above example, QI Macros tells you "Cannot Reject the Null Hypothesis because p > 0.05 (Variances are not Different).

**Interactive Results**:

QI Macros lets you change the significance level (cell E:1) to see what impact those changes have on your results.

Based on the F-test results, we now know which two sample t-test to run.

If you have non-normal data, consider running a Levene's test.