Improved statistical functions
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.