CHITEST

Returns the probability associated with a Pearson’s chi-squared test on the two ranges of data. Determines the likelihood that the observed categorical data is drawn from an expected distribution.

Sample Usage

CHITEST(A1:A5, B1:B5)

CHITEST(A1:D3, A5:D7)

Syntax

CHITEST(observed_range, expected_range)

  • observed_range - The counts associated with each category of data.

  • expected_range - The expected counts for each category under the null hypothesis.

Notes

  • observed_range and expected_range must both be ranges with the same number of rows and columns.

  • If any cell in either range is non-numeric, it and the corresponding cell in the other range do not count toward the calculation.

See Also

CHIDIST: Calculates the right-tailed chi-squared distribution, often used in hypothesis testing.

CHIINV: Calculates the inverse of the right-tailed chi-squared distribution.

CHISQ.DIST: Calculates the left-tailed chi-squared distribution, often used in hypothesis testing.

CHISQ.DIST.RT: Calculates the right-tailed chi-squared distribution, which is commonly used in hypothesis testing.

FTEST: Returns the probability associated with an F-test for equality of variances. Determines whether two samples are likely to have come from populations with the same variance.

TTEST: Returns the probability associated with t-test. Determines whether two samples are likely to have come from the same two underlying populations that have the same mean.

Example

Suppose you want to test the fairness of a 6-sided die. You count the number of times each side is rolled for 60 trials, and compare it to an expected distribution where each side is rolled 10 times. There is only a 5.1% chance that the die is actually fair.

  A B
1 Observed data Expected data
2 11 10
3 15 10
4 8 10
5 10 10
6 2 10
7 14 10
8 Solution Formula
9 0.05137998348 =CHITEST(A1:A6, B1:B6)

 

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Main menu
17681656031225307454
true
Search Help Center
true
true
true
true
true
35
false
false