Manuals/calci/FTEST

FTEST(Array1,Array2)

• and 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: and .
• The sample variances : and • Then the Test Statistic = has an F-distribution with 'n−1' and 'm−1' degrees of freedom.
• In FTEST(Array1,Array2) where is the data of first array, 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 or 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 .
• and are array of data.
• For e.g.,FTEST([15,29,30],[62,74,80])
F-Test

Examples

1.

 15 27 19 32
 21 12 30 11
=FTEST(B4:B8,C4:C8)=0.81524906747183

2.

 5 8 12 45 23
 10 20 30 40 50
=FTEST(A1:A5,C1:C5)=0.9583035732212274

3.

 14 26 37
 45 82 21 17
FTEST(B1:B3,C1:C4} = 0.26412211240525474

4.

 14
 45 65
=FTEST(B1,C2:C3)=NAN

F-Test