Chi-square test

Calculates the Chi-square test of a data sample.

แƒ‘แƒ แƒซแƒแƒœแƒ”แƒ‘แƒแƒ–แƒ” แƒฌแƒ•แƒ“แƒแƒ›แƒ˜แƒกแƒแƒ—แƒ•แƒ˜แƒก...

From the menu bar:

Choose Data - Statistics - Chi-square Test

From the tabbed interface:

Choose Data - Statistics - Chi-square Test.

On the Data menu of the Data tab, choose Statistics - Chi-square Test.


note

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


แƒ›แƒแƒœแƒแƒชแƒ”แƒ›แƒ”แƒ‘แƒ˜

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.

Open file with 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:

แƒ“แƒแƒ›แƒแƒฃแƒ™แƒ˜แƒ“แƒ”แƒ‘แƒšแƒแƒ‘แƒ˜แƒก แƒจแƒ”แƒ›แƒแƒฌแƒ›แƒ”แƒ‘แƒ (แƒฎแƒ˜-แƒ™แƒ•แƒแƒ“แƒ แƒแƒขแƒ˜)

alpha

0.05

df

12

P-แƒ›แƒœแƒ˜แƒจแƒ•แƒœแƒ”แƒšแƒแƒ‘แƒ

2.32567054678584E-014

แƒจแƒ”แƒ›แƒแƒฌแƒ›แƒ”แƒ‘แƒ˜แƒก แƒกแƒขแƒแƒขแƒ˜แƒกแƒขแƒ˜แƒ™แƒ

91.6870055842

แƒ™แƒ แƒ˜แƒขแƒ˜แƒ™แƒฃแƒšแƒ˜ แƒ›แƒœแƒ˜แƒจแƒ•แƒœแƒ”แƒšแƒแƒ‘แƒ

21.0260698175


Please support us!