Drexel dragonThe Math ForumDonate to the Math Forum



Search All of the Math Forum:

Views expressed in these public forums are not endorsed by Drexel University or The Math Forum.


Math Forum » Discussions » Courses » ap-stat

Topic: Excel for AP Statistics (fwd)
Replies: 1   Last Post: Feb 1, 1996 9:23 AM

Advanced Search

Back to Topic List Back to Topic List Jump to Tree View Jump to Tree View   Messages: [ Previous | Next ]
Bob Hayden

Posts: 2,384
Registered: 12/6/04
Excel for AP Statistics (fwd)
Posted: Jan 31, 1996 9:45 PM
  Click to see the message monospaced in plain text Plain Text   Click to reply to this topic Reply

>
> I have a question regarding software for AP Statistics. I have the list of
> suggested packages from the College Board, and instead of using one of
> those packages I'm wondering if Excel would suffice. It may be more
> economical for my school to use Excel and am wondering what the pros and
> cons would be.
>


I am just an interested bystander and I certainly do not speak for the
College Board or the test development committee.

There was a lengthy discussion of this question on EdStat-L recently.
Here is my opinion. Statistics was revolutionized in the 1960's by
the work of John Tukey and others. The AP Statistics course is
DEFINITELY post-Tukey. The stats. capabilities of Excel are
definitely pre-Tukey. If you just want to crunch numbers, it will do
it more or less, though you will have to write a LOT of code to get
the ANOVA table etc. that Minitab gives you with

regress 'y' vs. 1 ind. var. 'x'

to say nothing of residual plots and the like. I don't see "boxplots"
or "stem and leaf" in the index to my Excel 5 manual, and you
DEFINITELY do not want to code those yourself! It's not that those
two displays are so crucial, but their absence gives you an indication
of how many decades behind the times Excel is (3 or 4). In addition,
the EdStat-L gave indications that spreadsheets are equally out of
touch with the developments during the last 30-40 years in statisitcal
computing, so that wrong answers or problems with round-off errors are
a lot more likely than with any serious stats. package. A long list
of stats. functions is something you add to a spreadsheet as a
"feature". It's there to sell spreadsheets, not to do real work. To
put it in the context of high school mathematics -- using Excel to
teach an AP stats. course would be sort of like trying to implement
the NCTM Standards using an Algebra I text that was written in 1948 by
a plumber who had been on a school board.

If you are on PCs, there is a student version of NCSS (one of the
AP approved stats. packages) that runs under DOS and is free. You
can't get much more economical than that. I gave out many copies of
this at the AP stats. meeting in San Antonio last summer and it met
with general enthusiasm.

I do not have any financial interest in NCSS.
--


_
| | Robert W. Hayden
| | Department of Mathematics
/ | Plymouth State College
| | Plymouth, New Hampshire 03264 USA
| * | Rural Route 1, Box 10
/ | Ashland, NH 03217-9702
| ) (603) 968-9914 (home)
L_____/ hayden@oz.plymouth.edu
fax (603) 535-2943 (work)





Point your RSS reader here for a feed of the latest messages in this topic.

[Privacy Policy] [Terms of Use]

© Drexel University 1994-2014. All Rights Reserved.
The Math Forum is a research and educational enterprise of the Drexel University School of Education.