CHITEST

Formulas / CHITEST
Determine if a hypothesis is verified using an experiment.
=CHITEST( actual, expected )
  • actual_range - an array of observed frequencies
  • expected_range - an array of expected frequencies (must have the same dimension as the actual_range array and the values must be the same length)

Examples

  • =CHITEST(A1:A3,{20,15,15})

    The χ² statistic for the data indicated is 2.5 with 2 degrees of freedom; leading to a result value of 0.2865.


Summary

The CHITEST function is used to calculate the chi-squared value of a given distribution. It can be used to assess the difference between observed and expected results.

  • The CHITEST function is a worksheet function in Sourcetable used to calculate the chi-squared statistic for a data set.
  • It can be used in a formula in a worksheet cell.

Frequently Asked Questions

What is the CHITEST function?
The CHITEST function is used to test for independence in Sourcetable. It is available for backward compatibility with earlier versions of Excel and is replaced by the CHISQ.TEST function.
What does the CHITEST function do?
The CHITEST function tests for independence between two variables. This means that it checks to see if there is a relationship between two variables or if the variables are independent of one another.
How do I use the CHITEST function?
To use the CHITEST function, you must first enter the data into Sourcetable. Then, select the cells containing the data and open the function dialog box. In the function dialog box, enter the function name, followed by the data range. Finally, click “OK” to execute the function.
What are the limitations of the CHITEST function?
The CHITEST function is only available for backward compatibility with earlier versions of Microsoft Excel. As such, it does not have the same capabilities as the newer CHISQ.TEST function. Additionally, the CHITEST function does not support more than two variables.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV