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

From: Marc Schwartz <>
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.


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

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 mailing list PLEASE do read the posting guide 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 Please read the posting guide before posting to the list.

list of date sections of archive