Home › Functions › Statistical › =F.TEST()
Statistical Excel 2010 ◉ 23 views

=F.TEST()

Use this function to determine whether two samples have different variances.

Applies To: Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=F.TEST(array1,array2)
Hover argument names in the table for details.
Output typeNumber
Popularity8 / 100
VolatileNo
Dynamic ArrayNo
Download sample .xlsx ▦ Try in Playground Dedicated file for this function — safe & lightweight · sample data + live formulas
Share:

⬇ Download Sample Workbook

A dedicated .xlsx for =F.TEST() with Persian sample data & live formulas — open in Excel and practice.

  • Sheet “Sample” — data table + formula in place
  • Sheet “Guide” — syntax, arguments & tips from this page
  • Instant & secure (token + rate limit)
Download F.TEST.xlsx ~ 8–12 KB · No macros

⇪ Share

Send this function to friends

Quiz this function

%d questions — syntax, example & errors — test yourself!

◧ Arguments

ArgumentTypeRequiredDescription
array1 Array Required The first array or range of data.
array2 Array Required The second array or range of data.

▣ Examples

▦ Data
CellValue
A2 Data1
B2 Data2
A3 6
B3 20
A4 7
B4 28
A5 9
B5 31
A6 15
B6 38
A7 21
B7 40
A8 Data1
B8 Data2
A9 6
B9 20
A10 7
B10 28
A11 9
B11 31
A12 15
B12 38
A13 21
B13 40
F-test for the data sets in A2:A6 and B2:B6. =F.TEST(A2:A6,B2:B6)
Result: 0.64831785

§ Remarks

  • The arguments must be either numbers or names, arrays, or references that contain numbers.
  • If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
  • If the number of data points in array1 or array2 is less than 2, or if the variance of array1 or array2 is zero, F.TEST returns the #DIV/0! error value.

✦ Tips

  • The arguments must be either numbers or names, arrays, or references that contain numbers.
  • If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.

⚠ Common Errors

#DIV/0! If the number of data points in array1 or array2 is less than 2, or if the variance of array1 or array2 is zero, F.TEST returns the #DIV/0! error value.
Fix: Check the amount and values of the data

⇄ Related Functions

=T.TEST() Returns the probability associated with a Student's t-Test. Use T.TEST to determine whether two samples are likely to have come from the same two underlying populations that have the same mean. Results from the test shows if the difference is statistically significant or from chance. =F.DIST.RT() rticle describes the formula syntax and usage of the F.DIST.RT function in Microsoft Excel. Returns the (right-tailed) F probability distribution (degree of diversity) for two data sets. You can use this function to determine whether two data sets have different degrees of diversity. For example, you can examine the test scores of men and women entering high school and determine if the variability in the females is different from that found in the males. =VAR.S() The VAR.S function estimates variance based on a sample (ignores logical values and text in the sample).

💬 Comments & Q&A 0 approved

🔒 Your comment will be published after review.

Share your thoughts — visible after admin approval

No comments yet — be the first!

✍️ Add comment / question

captcha
🔒 Your comment will be published after review.