Buzz
This article introduces you to the CHISQ.DIST function – one of the statistical functions highly favored in Excel.
Description: The function returns the distribution when squared, commonly used to analyze variations in percentages of samples. This function is supported from Excel 2010 onwards.
Syntax: CHISQ.DIST(x, deg_freedom, cumulative)
In this context:
- x: Value to assess the distribution.
- deg_freedom: Degree of freedom.
- cumulative: Logical value determining the form of the function, including:
+ cumulative = True -> returns the cumulative distribution function.
+ cumulative = False -> returns the probability density function.
Note:
- If any parameter values are non-numeric -> the function returns an error value #VALUE!
- If x < 0 -> the function returns an error value #NUM!
- If deg_freedom is not an integer -> it is truncated to the nearest integer.
- If deg_freedom < 1 or deg_freedom > 10^10 -> the function returns an error value #NUM!
Example:
Calculate the distribution when squared, presented as the cumulative distribution function and probability density function based on the data in the table below:
- Calculate the distribution when squared in the form of the cumulative distribution function. In the cell to be calculated, enter the formula: =CHISQ.DIST(C6,C7,C8)
- Press Enter -> the distribution when squared in the form of the cumulative distribution function is:
- Calculate the distribution when squared in the form of the probability density function. In the cell to be calculated, enter the formula: =CHISQ.DIST(C6,C7,C9)
- Press Enter -> the distribution when squared in the form of the probability density function is:
Here are instructions and specific examples when using the CHISQ.DIST function in Excel.
Wishing you all success!
