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.
Search JabSto ::




Custom Search