On Jun 17, 2010, at 3:03 PM, Ted Harding wrote:

> The thread "R licensing query" currently running has raised
> the classic critcisms of using Excel for statistics.
> 
> I was wondering: Has anyone applied the same or similar set
> of tests to OpenOffice "calc"?
> 
> Or would the Executive Summary be: "Calc is just like Excel"?
> 
> (Not that I'm a spreadsheet user, if I can avoid it; but I
> sometimes get asked about such things).
> 
> Sorry to be completely non-R here, but I can't think of a
> better place to ask!
> 
> Ted.


Ted,

The most recent work on this that I know of, that includes Calc, is:

On the Numerical Accuracy of Spreadsheets
Marcelo G. Almiron, Bruno Lopes, Alyson L. C. Oliveira, Antonio C. Medeiros, 
Alejandro C. Frery
JSS
Vol. 34, Issue 4, Apr 2010
http://www.jstatsoft.org/v34/i04


There have been some discussions on R-Help in the past (circa 2003), which I 
have participated in, which discuss some of the faults in Calc, such as 
rounding numbers "close to 0" to 0 (like Excel does) and some of the non-IEEE 
754 floating point behavior (like Excel does)...

HTH,

Marc Schwartz

______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

Reply via email to