Returns the probability associated with an F-test for equality of variances. Determines whether two samples are likely to have come from populations with the same variance.
Sample usage
FTEST(A1:A5, B1:B5)
FTEST(A1:D3, A5:D7)
Syntax
FTEST(range1, range2)
-
range1
– The first sample of data or group of cells to consider for the F-test. -
range2
– The second sample of data or group of cells to consider for the F-test.
Notes
-
Any non-numeric cells in either range are ignored in the calculation.
-
You can use
FTEST
or F.TEST to perform this function.
See also
CHITEST
: Returns the probability associated with a Pearson’s chi-squared test on the two ranges of data. Determines the likelihood that the observed categorical data is drawn from an expected distribution.
FDIST
: Estimates the right-tailed F probability distribution (degree of diversity) for two data sets with given input x. Alternatively called Fisher-Snedecor distribution or Snedecor's F distribution.
FINV
: Calculates the inverse of the right-tailed F probability distribution. Also called the Fisher-Snedecor distribution or Snedecor’s F distribution.
TTEST
: Returns the probability associated with t-test. Calculates whether two samples are likely to have come from the same two underlying populations with the same mean.
Example
Suppose you want to determine whether exam scores from this term have a different variability from those of last term. Pass the scores from each semester as arguments to FTEST
. Because the p-value is high, we can conclude that there is not a significant difference in variability in exam scores.
A | B | |
---|---|---|
1 | Scores this term | Scores last term |
2 | 92 | 84 |
3 | 75 | 89 |
4 | 97 | 87 |
5 | 85 | 95 |
6 | 87 | 82 |
7 | 82 | 71 |
8 | 79 | |
9 | Solution | Formula |
10 | 0.8600520777 | =FTEST(A2:A8, B2:B7) |