I think Tom has explained quite clearly what the problem is:
==================================
>I am a statistical near-illiterate, trying to write an introduction to stats
for real stats illiterates, using Excel data analysis functions.
==================================
Obviously a suboptimal situation -- both the teacher, the students, and
the tool are far from perfect. I think the advice Herman gives is
"at best useless", because it does not deal with the given situation, and
does not even try to answer the question. It simply says: You have to become
fully literate first, and then we'll talk.
Here are some (incomplete) answers
http://www.stats.gla.ac.uk/cti/activities/reviews/96_11/excel/intro.html
http://www.stats.gla.ac.uk/cti/activities/reviews/96_05/excel.html
http://www-unix.oit.umass.edu/~evagold/excel.html
http://www.man.deakin.edu.au/rodneyc/XLStats.htm
and, from Purdue of all places,
http://www.stat.purdue.edu/~bacraig/stat503.html
with Excel instructions and modules.
At 8:41 AM -0500 12/28/99, Herman Rubin wrote:
>In article <8476b5$j7$[EMAIL PROTECTED]>,
>Thomas A Torda <[EMAIL PROTECTED]> wrote:
> >I am a statistical near-illiterate, trying to write an introduction to stats
> >for real stats illiterates, using Excel data analysis functions. I have
> >problems with some of the procedures and would be interested to know the
> >algorithms used. Does anyone know whether these can be found or whether
> >anything has been written on the use of Excel as a stats resource?
> >The covariance and the two factor Anova especially appear a bit odd.
> >Thanks,
> >Tom Torda
> >[EMAIL PROTECTED]
>
>
>What are you trying to do? What you should be doing is
>pointing out what problems are answered, and what it
>means. Knowing how to compute is at best useless, if one
>does not know what the meaning of the results.
>
>In fact, it can be far worse than useless. It is putting
>a loaded statistical gun in the hands of a statistical
>ignoramus. One does not teach the mechanics of brain
>surgery to someone ignorant of anatomy and physiology.
>
>
>
>
>--
>This address is for information only. I do not claim that these views
>are those of the Statistics Department or of Purdue University.
>Herman Rubin, Dept. of Statistics, Purdue Univ., West Lafayette IN47907-1399
>[EMAIL PROTECTED] Phone: (765)494-6054 FAX: (765)494-0558
===
Jan de Leeuw; Professor and Chair, UCLA Department of Statistics;
US mail: 8142 Math Sciences Bldg, Box 951554, Los Angeles, CA 90095-1554
phone (310)-825-9550; fax (310)-206-5658; email: [EMAIL PROTECTED]
http://www.stat.ucla.edu/~deleeuw and http://home1.gte.net/datamine/
============================================================================
No matter where you go, there you are. --- Buckaroo Banzai
============================================================================
