CHISQ.DIST
Formulas / CHISQ.DISTReturn the chi-squared distribution.
CHISQ.DIST(x,deg_freedom,cumulative)
- x - the value to evaluate the distribution from
- deg_freedom - the number of degrees of freedom
- cumulative - determines the form of the function
Examples
=CHISQ.DIST.RT(A2,A3)To use the CHISQ.DIST function to calculate the one-tailed probability of the chi-squared distribution for the arguments specified in A2 and A3, you would enter the formula above in a Sourcetable cell. This will return the one-tailed probability of the chi-squared distribution for the arguments specified in A2 and A3.
Summary
The CHISQ.DIST function calculates the chi-squared distribution, used to study variation in percentages in samples. It requires three arguments, and returns an error if any argument is not numeric.
- The CHISQ.DIST function takes three arguments which are required: X, deg_freedom, and cumulative.
- The chi-squared distribution is used to analyze variation in the percentage of something in samples.
Frequently Asked Questions
What is the CHISQ.DIST function?
The CHISQ.DIST function calculates the chi-squared distribution, which is commonly used to study variation in the percentage of something across samples.
What is the chi-squared distribution used for?
The chi-squared distribution is used to determine whether samples are statistically different.
What errors does the CHISQ.DIST function throw?
- The CHISQ.DIST function throws a #NUM! error if x is negative.
- The CHISQ.DIST function throws a #VALUE! error if any argument is not a number.
- The CHISQ.DIST function throws a #NUM! error if deg_freedom < 1 or deg_freedom > 10^10.
