F-test

Calculates the F-Test of two data samples.

Toiminnon kÀyttÀminen:

ValikkoriviltÀ:

Choose Data - Statistics - F-test

VÀlilehdellisestÀ kÀyttöliittymÀstÀ:

Choose Data - Statistics - F-test.

On the Data menu of the Data tab, choose 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.

Grouped By

Select whether the input data has columns or rows layout.

Avaa esimerkkitiedosto:

Example

The following table has two data sets.

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!