Chi-square test

Calculates the Chi-square test of a data sample.

To access this command...

Choose Data - Statistics - Chi-square Test


note

For more information on chi-square tests, refer to the corresponding Wikipedia article.


Data

Input Range: The reference of the range of the data to analyze.

Results to: The reference of the top left cell of the range where the results will be displayed.

Grouped By

Select whether the input data has columns or rows layout.

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 Chi-square Test:

Test of Independence (Chi-Square)

Alpha

0.05

df

12

P-value

2.32567054678584E-014

Test Statistic

91.6870055842

Critical Value

21.0260698175


Please support us!