# How to Use FTEST in Google Sheets in 2020?

FTESTReturns 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.

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: Calculates the right-tailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately 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. Determines whether two samples are likely to have come from the same two underlying populations that have the same mean.

Example

Suppose you want to determine whether exam scores from this semester have a different variability than last semester. 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 semester
Scores last semester

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)

Categories Uncategorized Tags