F-test

Calculates the F-Test of two data samples.

Aby wykonać tę operację...

Choose Data - Statistics - F-test


A F-test is any statistical test based on the F-distribution under the null hypothesis.

note

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.

Grupowanie według

Wybierz, czy dane wejściowe mają układ kolumnowy lub wierszowy.

Przykład

Poniższa tabela ma dwa zestawy danych.

A

B

1

28

19

2

26

13

3

31

12

4

23

5

5

20

34

6

27

31

7

28

31

8

14

12

9

4

24

10

0

23

11

2

19

12

8

10

13

9

33


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


Please support us!