On Fri, 4 Mar 2011 01:18:17 -0500, "Ed Huntress"
wrote:
snip
He does the arithmetic parts of that in Excel. Then he imports it (usually)
into SAS, where he applies higher statistical methods. The trick to making
this work well, aside from having good ideas and insights about how to
normalize and adjust the raw data to produce the value you're looking for,
is to automate as many tasks as you can.
snip
As long as you have less than about 64k records [lines] and
ample memory, take a look at an Excel statistics package
add-in.
The one I use is WinStat
http://www.winstat.com/ 99$US
Everything up to but not including canonical analysis. As it
is an Excel add-in charts and graphs are easy to generate to
include in the reports.





-- Unka George (George McDuffee)
...............................
The past is a foreign country;
they do things differently there.
L. P. Hartley (1895-1972), British author.
The Go-Between, Prologue (1953).