Statistics illustrated with spreadsheets

Statistics, illustrated with spreadsheets

As a long-term high school math / computer teacher, I've written a number of odd files. This page provides a summary and links to them.

All of them are Microsoft Excel spreadsheets

About macros - a discussion of the potential perils of, and how to use Microsoft macros.
Baseball - illustrates the beginning of hypothesis testing. Do an experiment many times - what results are you likely to get? Based on the question of whether pitchers tried to stop Hank Greenberg's home run record chase with an inflated number of walks.
Central Limit Theorem - illustrates the Central Limit Theorem by graphing the results of many calculated means of different non-normal distributions.
Pi-Darts - my favorite problem since shown it in high school in 1967. Calculate pi by throwing darts at a dartboard!
Solving simultaneous equations - a quick, illustrated solution to solving two linear equations with two unknowns, with some thoughts on teaching this subject.

I'm happy to correspond about these - e-mail me at stat@tryonhayes.com

Pete Tryon