[6292] in s-news-athena
Re: Excel
daemon@ATHENA.MIT.EDU (Duncan Murdoch)
Fri Jan 27 17:55:58 1995
To: s-news@utstat.toronto.edu
From: dmurdoch@mast.QueensU.CA (Duncan Murdoch)
Date: Fri, 27 Jan 1995 17:25:32
Cc: feh@biostat.mc.duke.edu
In article Frank Harrell <feh@biostat.mc.duke.edu> writes:
>It's strange to see S-Plus mentioned in the same paragraph with Excel.
>One of the most basic statistical operations is becoming the generation
>of a scatterplot with a loess-smoothed trend line added. I'd like
>to see someone do this with Excel.
I don't know Excel, but I suspect that it would simply be a matter of
programming a general loess function, and adding the module to Excel. Since
loess source is available, this wouldn't be hard. Certainly this description
applies to Quattro Pro, which I do know -- loess isn't there, but adding it is
a straightforward thing for a programmer to do.
Quattro Pro does have running mean smoothing already.
It would be no harder to add loess to a modern spreadsheet than it would be to
add some new smoother to S-Plus.
Duncan Murdoch
