CHIDIST Excel Formula

Author Zaheer    Category Formulas     Tags ,

The Distribution and Tests of Probability is under the Excel Statistical Function wherein you can perform basic and complex statistical calculations. These calculations range from computing the mean, median, and mode, up to probability tests. Some of the Excel Statistical Functions are not readily available in older versions of Excel.

Included in the Distribution and Tests of Probability subgroup is the CHIDIST function. This function computes the one-tailed probability of the chi-square distribution.  The ?2 distribution is linked to a ?2 test and compares the observed and expected values.

The syntax of the CHIDIST function is CHIDIST(x,degrees_freedom). In the syntax, the argument x is the numeric value from which the chi-square distribution will be evaluated. Moreover, the argument degrees_freedom is the number or quantity of degrees of freedom.

The common error that occurs in the CHIDIST function are the #VALUE! error and #NUM! error. The #VALUE! error occurs if one of the argument or both is supplied with non-numeric data. The #NUM! error occurs when the value of the x argument is negative, if the given value for the degrees_freedom is lesser than 1, and if the degrees_freedom isgreater than 10^10. Moreover, if the given value of the  degrees_freedom is not an integer then it will be automatically truncated.

You can try a sample of the function by first opening a blank Excel worksheet or spreadsheet. After, select the cell A2 data and input the value 18.307 and in cell A3 input the value 10. For the formula, input it on cell A4 which is as follows =CHIDIST(A2,A3) and the result would be 0.050001. This example is for giving values that are from a source cell.

Another example is to input the values automatically in the syntax. This could be done by selecting a blank cell and inputting the formula =CHIDIST(0.5,1) and the result would be 0.479500122.

View the results of the formula by hitting Ctrl+` (grave accent) and you can do the same to switch the view from formula to results. Another option for viewing is by selecting the Formulas tab and select the Formula Auditing group and from the list select the Show Formulas.

Post comment