Home » Statistical Analysis Excel » F-Test

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

QI Macros can do it for you!

QI Macros Add-in for Excel Makes F-Tests as Easy as 1-2-3

1. Click and drag over your data to select it in Excel:



2. Click on the QI Macros Menu > Statistical Tools > F & t Tests, and then select "F-test: Two-sample for Variance":



3. QI Macros will prompt for a significance level (default = 0.05):



4. QI Macros will perform the F-Test calculations and interpret the results for you:

---

What's Cool about QI Macros F-Test?

Interprets the Results for You: QI Macros 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/Accept the Null Hypothesis," because p > 0.05 (Variances are not Different/Variances are the Same).

Interactive Results: QI Macros lets you change the significance level 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.

---