F Test Statistics in Calc /text/scalc/01/statistics_test_f.xhp Analysis toolpack;F-test F-test;Analysis toolpack Data statistics;F-test

F-test

Calculates the F-Test of two data samples.

Choose Data - Statistics - F-test

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