F-Tests Determine if Variances are the Same or Different
You Don't Have to be a Statistician to do an F-Test in Excel
QI Macros Add-in for Excel Makes F-Tests as Easy as 1-2-3
- 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:
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 because p > 0.05 (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.
If you're producing rubber made with two different recipes, you might want to know if the variances in tensile strengths are the same or different (Juran's QC Handbook 4th pg 23.74):
Why Choose QI Macros Statistical Software for Excel?
- 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