Re: [R] [OT] Oo-calc & StAtistics

From: Marc Schwartz <marc_schwartz_at_me.com>
Date: Thu, 17 Jun 2010 15:36:27 -0500

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_at_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. Received on Thu 17 Jun 2010 - 20:39:23 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Thu 17 Jun 2010 - 21:40:32 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive