Improved statistical functions

Microsoft Office Excel 2003

What's new in Microsoft Office Excel 2003

Improved statistical functions

What's new home

Aspects of the following statistical functions, including rounding results, and precision have been enhanced:

BINOMDIST
CHIINV
CONFIDENCE
CRITBINOM
DSTDEV
DSTDEVP
DVAR
DVARP
FINV
FORECAST
GAMMAINV
GROWTH
HYPGEOMDIST
INTERCEPT
LINEST
LOGEST
LOGINV
LOGNORMDIST
NEGBINOMDIST
NORMDIST
NORMINV
NORMSDIST
NORMSINV
PEARSON
POISSON
RAND
RSQ
SLOPE
STDEV
STDEVA
STDEVP
STDEVPA
STEYX
TINV
TREND
VAR
VARA
VARP
VARPA
ZTEST

Note  The result of the preceding functions may be different than in previous versions of Microsoft Excel.