The CHISQ.DIST function calculates the probability of the chi-squared distribution. Use this function to check if a hypothesize is valid. It allows you to calculate the cumulative distribution or the probability density function.
The CHISQ.DIST function was introduced in Excel 2010 and has replaced the CHIDIST function.
Formula in cell C6:
Excel Function Syntax
Required. A numerical value representing a point in the probability distribution you want to be evaluated.
Required. A numerical value representing the degrees of freedom.
Required. A boolean value.
TRUE - Cumulative distribution function
FALSE - Probability density function
The CHISQ.DIST function returns
#VALUE! error value if x, deg_freedom or cumulative argument is non-numeric.
This extensive function reference list provides detailed information including syntax, arguments, return values, and examples for many of the functions used in Excel formulas. Click on headers to sort table.
Functions in 'Statistical'
The CHISQ.DIST function function is one of many functions in the 'Statistical' category.