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 firstname.lastname@example.org
Return to Pete's Personal Website
Tryon's Tech Help Pages