Microsoft Office Tutorials and References

In Depth Information

**Functions That Have Been Renamed**

Functions That Have Been Renamed

Before Excel 2010, the statistical functions had been poorly named. Depending

on the distribution that you were using, the naming conventions varied. For

the Chi Squared distribution, the inverse function was called CHIINV. For

the Binomial distribution, the inverse function was called CRITBINOM.

Starting in Excel 2010, the existing statistical functions have been renamed.

Watch for these suffixes:

•
.DIST is used for the probability density function and for the left-

tailed cumulative distribution function. An argument explains whether

the function is the PDF (point distribution function) or the CDF (cu-

mulative distribution function).

•
.INV is used for the inverse cumulative distribution function.

•
.RT is used for right-tailed.

•
.LT is used for left-tailed.

•
.TEST is used for hypothesis-testing functions.

•
.P is used for functions based on a population.

•
.S is used for functions based on a sample.

Table 14.2
shows a list of all the distribution function names.