Archive for Wednesday, May 21st, 2008
Excel 2007 Regression Error - Fixed in SP1
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.
In Calculation Bug Fixed, an old but ongoing thread in the Daily Dose of Excel blog, I mentioned a problem with Excel 2007’s trendline regression formulas. Apparently small regression coefficients were treated like small errors that occur in the insignificant digits when converting from binary to decimal. I had documented the error in May of [...]
Posted: Wednesday, May 21st, 2008 under Excel 2007, Statistics.
Comments: none
