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

  1. Enter your data in Excel. Then select you data and click on the QI Macros Menu, Statistical Tools and then the F-Test:
  2. f test example in the QI Macros

  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.
f test calculations using the QI Macros for Excel

What's Cool about the 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.

F-Test Video Example

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?

affordable

Affordable

  • Only $249 - less with quantity discounts
  • No annual fees
  • Free Technical Support

easy to use

Easy to Use

  • Works Right in Excel
  • Interprets Results for You
  • Accurate Results Without Worry

proven and trusted

Proven and Trusted

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