Excel CHISQ.DIST Function
The CHISQ.DIST function returns the left-tailed probability of the chi-squared distribution. Use this function to study variation in the percentage of something across samples.
The CHISQ.DIST function returns a numeric value.
- If the deg_freedom argument is not an integer, the CHISQ.DIST function will truncate it to an integer.
- The #VALUE! error value occurs when any of the arguments is non-numeric.
- The #NUM! error value occurs if:
- the supplied x argument is < 0
- the supplied deg_freedom argument is < 1 or > 10^10
- The CHISQ.DIST function is newly introduced in Excel 2010, so it is not available in earlier versions of Excel.
In this case, we want to calculate left-tailed probability of the chi-squared distribution based on the data provided in the table below, please do as follows.
1. Please copy the formula below into cell F5, then press the Enter key to get the result.
2.Select this result cell and drag its autofill handle down to get the rest of the results.
- We can also directly input a value in the formula. For example, the formula in cell F5 can be changed to:
Excel EVEN Function
The EVEN function rounds numbers away from zero to the nearest even integer.
Excel EXP Function
The EXP function returns the result of the constant e raised to the nth power.