Hi, I found the following paper several weeks ago in [1] (written in Japanese) that descrives about the paper that Pedro mentioned.
"On the accuracy of statistical procedures in Microsoft Excel 2010", Submitted but rejected, January 2012 http://homepages.ulb.ac.be/~gmelard/Recherche.htm And I have seen some people want to use tool such as data analysys tools provided on Excel. There is Apache Commons Math library provides statistical tools written in Java. It is good stuff to make analysis tool as an extension also, if someone wanted. I have started to make such thing but it's discontinued. [1] http://oku.edu.mie-u.ac.jp/~okumura/blog/node/2585 Tsutomu 2012/12/7, Pedro Giffuni <p...@apache.org>: > Hi guys; > > FWIW, while I was playing with the new random number generator I went > around looking for some references and I found this paper from the Journal > of Statistical Software (2010) titled "On the Numerical Accuracy of > Spreadsheets": > > http://www.jstatsoft.org/v34/i04/paper > > > It basically shows that Calc, among other Spreadsheet programs, is not > really well suited for statistical analysis. > > Something rather amazing is that the major statistic suites have been moving > towards a more "spreadsheet-like" environment. I am personally a fan of > Minitab as it brings many functions that I needed for Quality control in a > previous job. The price of the software package sky-rocketed in few years > though :(. > > One approach could be improving our local functions to match more > demanding specifications: some of that will necessarily have to be done. > Another approach could be facilitating interactions with software like R, > > and I am aware that approach has many followers. A third approach, which > I would like to suggest as a future project, would be developing a scaddin > focused on statistics and making full use of the functions from boost that > we already have available as a module but we are not using to their full > extent. > > I know we are all busy with other stuff to improve for 4.0 Release, just > thought I'd leave the idea for the future. > > cheers, > > Pedro.
