CHITEST

The CHITEST function in Google Sheets returns the probability associated with a Pearson's chi-squared test, letting you determine how likely it is that a set of observed data was drawn from an expected distribution. It's a go-to tool for hypothesis testing on categorical data. Dive into our comprehensive guide to master its application.

Parameters

• observed_range: The range of cells containing the observed values.
• expected_range: The range of cells containing the expected values, matching the shape of observed_range.

Step-by-Step Tutorial

1. Testing observed vs. expected data:
   • Example: If A1:A4 holds observed counts 10, 15, 20, 5 and B1:B4 holds expected counts 12, 12, 18, 8, then =CHITEST(A1:A4, B1:B4) returns the p-value for how well the observed data fits the expectation.
   • Result: A probability value between 0 and 1; smaller values indicate a larger discrepancy between observed and expected data.

Use Cases and Scenarios

1. Market Research: Test whether customer preferences match an expected distribution across product categories.
2. Quality Assurance: Compare actual defect rates against expected rates across production batches.
3. Genetics and Biology: Verify whether observed trait ratios match theoretical Mendelian expectations.

Related Functions

• CHIDIST: Calculates the right-tailed chi-squared distribution.
• CHISQ.DIST: Returns the left-tailed chi-squared distribution.

Related Articles

• Understanding Statistical Functions in Google Sheets