CHITEST

The CHITEST function in Google Sheets is used to calculate the probability associated with a Pearson's chi-squared test on two ranges of data. This function helps determine the likelihood that the observed categorical data is drawn from an expected distribution.

Function Syntax and Parameters

Syntax: CHITEST(observed_range, expected_range)

Parameters:

• observed_range: The range of cells containing the observed data.
• expected_range: The range of cells containing the expected data.

Step-by-Step Tutorial

Here is an example of how to use the CHITEST function:

1. Using CHITEST with observed and expected data:
   • Example: If A1:A5 has observed data and B1:B5 has the expected data, use =CHITEST(A1:A5, B1:B5).

Use Cases and Scenarios

1. Statistical Analysis: Determine the likelihood of observed categorical data being drawn from an expected distribution.

Related Functions

• None

Related Articles

• None