Archive for Wednesday, May 21st, 2008
Excel 2007 Regression Error - Fixed in SP1
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2009.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
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.
Comments: 1
