3 ms·
Calc (from OpenOffice) was analyzed among others in 2010 "On the numerical accuracy of spreadsheets, Journal of Statistical Software, 34, 4, 1-29." http://www.
by adulau 14y ago
Calc (from OpenOffice) was analyzed among others in 2010 "On the numerical accuracy of spreadsheets, Journal of Statistical Software, 34, 4, 1-29."
http://www.jstatsoft.org/v34/i04 http://www.jstatsoft.org/v34/i04
"
This paper discusses the numerical precision of five spreadsheets (Calc, Excel, Gnumeric, NeoOffice and Oleo) running on two hardware platforms (i386 and amd64) and on three operating systems (Windows Vista, Ubuntu Intrepid and Mac OS Leopard). The methodology consists of checking the number of correct significant digits returned by each spreadsheet when computing the sample mean, standard deviation, first-order autocorrelation, F statistic in ANOVA tests, linear and nonlinear regression and distribution functions. A discussion about the algorithms for pseudorandom number generation provided by these platforms is also conducted. We conclude that there is no safe choice among the spreadsheets here assessed: they all fail in nonlinear regression and they are not suited for Monte Carlo experiments."
- chris_wot 14y agoI'm curious as to why use a Spreadsheet for statistical functions if they cannot be trusted?
- regularfry 14y agoBecause they claim to support statistical functions, their users expect them to be able to do it, their users already have the spreadsheet software and know how to use it, and knowledge that they can be dangerously broken is not widespread.