# The Measurement of Adolescents, II

## Statistics and Spreadsheets

Your feedback is important to us!

After viewing our curriculum units, please take a few minutes to help us understand how the units, which were created by public school teachers, may be useful to others.

## Lesson 11

### Objectives:

1. To find the deviation from the mean.2. To find the sum of the deviations from the mean.

3. To create a formula using absolute and relative cell addresses.

### Directions:

1. Move to the following cells and create right-aligned labels.CELL | LABEL |

F4 | Deviation |

F5 | from the |

F6 | Mean |

F7 | ——— |

F24 | ——— |

Move the cursor to F8.

- 2. Let’s see how many games Pam scored above her average and how many games Pam scored below her average.

Press + to get into Value Mode.

Move the cursor to E8 to get Pam’s points for Norwalk.

Press to subtract.

Move the cursor to E26 to get Pam’s average.

Press function key [F4] to make E26 absolute.

Press [ENTER] to enter the formula.

3. Let’s make the number’s appearance more understandable.

Press / to bring up the Main Menu.

Select Range.

Select Format.

Select Fixed.

1-2-3 offers 2 as the suggested number of decimal places.

Type 1 to override 1-2-3’s prompt.

Press [ENTER]

4. Let’s copy the formula for the rest of the games.

Press / to bring up the Main Menu.

Press [ENTER] since we just want to copy the one cell.

Type F9 as the first cell in the target range.

Press . to anchor the target.

Type F23 as the final target.

Press [ENTER]

5. We’ve already created an SUM formula. Let’s copy it.

Move the cursor to E25.

Press / to bring up the Main Menu.

Press [ENTER] since we just want to copy the one cell.

Type F25 as the target range.

Press [ENTER]

Notice that the sum of the deviations from the mean is zero!

6. Resave the file.