Chi-square test

Calculates the Chi-square test of a data sample.

To access this command...

Choose Data - Statistics - Chi-square Test

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 analyse.

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:

Related Topics

• Sampling
• Descriptive Statistics
• Analysis of Variance (ANOVA)
• Correlation
• Covariance
• Exponential Smoothing
• Moving Average
• Regression Analysis
• Paired t-test
• F-test
• Z-test
• Chi-square test
• Fourier Analysis