FTEST(Array1,Array2)
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array1}
and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array2 }
are array of data.
- FTEST(), returns the result of an F-test.
Description
- This function gives the result of F-test.
- The F-test is designed to test if two population variances are equal.
- It does this by comparing the ratio of two variances.
- So, if the variances are equal, the ratio of the variances will be 1.
- Let X1,...Xn and Y1,...Ym be independent samples each have a Normal Distribution .
- It's sample means:
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle \bar X=\frac{1}{n} \sum_{i=1}^n Xi}
and
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle \bar Y =\frac {1}{m} \sum_{i=1}^m Yi}
.
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle SX^2=\frac{1}{n-1} \sum_{i=1}^n (Xi-\bar X)^2}
and
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle SY^2=\frac{1}{m-1} \sum_{i=1}^m (Yi-\bar Y)^2}
- Then the Test Statistic = Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle \frac {Sx^2}{Sy^2}}
has an F-distribution with 'n−1' and 'm−1' degrees of freedom.
- In FTEST(Array1,Array2) where Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array1}
is the data of first array, Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array2}
is the data of second array.
- The array may be any numbers, names, or references that contains numbers.
- values are not considered if the array contains any text, logical values or empty cells.
When the Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array1}
or Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array2}
is less than 2 or the variance of the array value is zero, then this function will return the result as error.
ZOS
- The syntax is to calculate FTEST in ZOS is Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle FTEST(Array1,Array2)}
.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array1}
and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array2 }
are array of data.
- For e.g.,FTEST([15,29,30],[62,74,80])
Examples
1.
=FTEST(B4:B8,C4:C8)=0.81524906747183
2.
=FTEST(A1:A5,C1:C5)=0.9583035732212274
3.
FTEST(B1:B3,C1:C4} = 0.26412211240525474
4.
=FTEST(B1,C2:C3)=NAN
Related Videos
See Also
References
F Test