Manuals/calci/FTESTANALYSIS
FTESTANALYSIS(Array1, Array2, Alpha, NewTableFlag)
where,
Array1 and Array2 - Input range should be one blocks.
Alpha - is a constant and value should be in between 0 and 1.
NewTableFlag - is the TRUE or FALSE.If set as TRUE,the result in new sheet.If NewTableFlag is omitted, it assumed to be FALSE.
F-Test Two Sample for Variances is also knowns as Fisher test. It compares the variances between two groups of data. Variance is a measure of how much the values are dispersed around the mean value.
If Alpha < 0 or Alpha >1, FTESTANALYSIS returns the #ERROR.
F-TEST TWO SAMPLE FOR VARIANCES
Lets see an example in (Column3, Row1)
=FTESTANALYSIS(R1C1:R6C1, R1C2:R6C2, 0.05, TRUE)
It returns the result in new sheet(5Sapce).
=FTESTANALYSIS(R1C1:R3C2, R1C2:R3C2, -1, TRUE)
It returns the #ERROR(Alpha =-1).
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 8 | 3 | 5Space | 5 |
| Row2 | 7 | 8 | 9 | 128 |
| Row3 | 12 | 9 | 14 | 15 |
| Row4 | 17 | 18 | 10000 | 20 |
| Row5 | 44 | 35 | #ERROR | 168 |
| Row6 | 6 | 2 | 1.619775 | 0.525322 |
| Variable1 | Variable2 | |
|---|---|---|
| Mean | 15.666666666666666 | 12.5 |
| Variance | 209.0666666666667 | 153.9 |
| Observations | 6 | 6 |
| Degree Of Freedom | 5 | 5 |
| F Value | 1.3584578730777563 | |
| P(F<=f) one-tail | 0.37247330494764646 | |
| F Critical one-tail | NaN |