CHISQ.DIST()

Syntax. CHISQ.DIST(x,degrees_freedom,cumulative)

Definition. This function returns the values of the chi-squared distribution. The chi-squared distribution is often used to examine the variance across samples. For example, you can calculate the percentage of time people spend every day watching TV.

Arguments

  • x (required). The value (quantile) for which you want to calculate the probability (1-alpha).

  • degrees_freedom (required). The number of degrees of freedom.

  • cumulative (required). The logical value. If cumulative is TRUE, the cumulative distribution is returned; otherwise, the probability density function is returned.

Note

If one of the arguments isn’t a numeric value, the CHISQ.DIST() function returns the #VALUE! error.

If x is negative, ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.