F-test
Calculates the F-Test of two data samples.
A F-test is any statistical test based on the F-distribution under the null hypothesis.
For more information on F-tests, refer to the corresponding Wikipedia article.
Data
Variable 1 range: The reference of the range of the first data series to analyze.
Variable 2 range: The reference of the range of the second data series to analyze.
Results to: The reference of the top left cell of the range where the test will be displayed.
Results for F-Test:
The following table shows the F-Test for the data series above:
|
Ftest |
||
|
Alpha |
0.05 |
|
|
Variable 1 |
Variable 2 |
|
|
Mean |
16.9230769231 |
20.4615384615 |
|
Variance |
125.0769230769 |
94.4358974359 |
|
Observations |
13 |
13 |
|
df |
12 |
12 |
|
F |
1.3244637524 |
|
|
P (F<=f) right-tail |
0.3170614146 |
|
|
F Critical right-tail |
2.6866371125 |
|
|
P (F<=f) left-tail |
0.6829385854 |
|
|
F Critical left-tail |
0.3722125312 |
|
|
P two-tail |
0.6341228293 |
|
|
F Critical two-tail |
0.3051313549 |
3.277277094 |