# The Measurement of Adolescents, II

## Statistics and Spreadsheets

## Guide Entry to 86.05.04

Let’s analyze the way that Lee beat Cross and then Hillhouse. A quick way is with one of the different types of graphs. See how not every picture tells a true story? Now let’s employ some statistics. We’ll find ranges. Move to the arithmetic mean. Then to deviation. Not my students you say? Take heart, this method works.

A spreadsheet is better than a calculator. You don’t lose the numbers. They stay on the screen. You can actually see where the variance is coming from. You can play what-if. Make one score closer to the mean and see the changes.

But you say you don’t like Pam? No problem. Use one of your own students. In fact, that’s the preferred method. Everyone likes to talk about themselves. Now your classes are interesting. Now you’re a good teacher.

You can also teach this unit without a computer. I developed most of the exercises when I had a remedial class with two boy basketball players in it. I would recommend calculators, then, so the students don’t get bogged down in the formulas.

(Recommended for Data Entry classes, grade 10; Applied Mathematics classes, grade 9)

**
Key Words
**

*
Statistics Basic Skills Mathematics Probability Spreadsheets
*