# 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 5

### Objectives:

- 1. To use 1-2-3’s Statistical Functions.

### Directions:

- 1. Move to the following cells and create left-aligned labels.

CELL | LABEL |

A24 | ——— |

A25 | Total |

A27 | Maximum |

A28 | Minimum |

A30 | # of Games |

- 2. Move to the following cells and create right-aligned labels.

CELL | LABEL |

C24 | ——— |

D24 | ——— |

E24 | ——— |

Move the cursor to E25.

- 3. Using the SUM function, find the total of Pam’s points.

Type SUM(

Did you see the (bracket? Quite often I miss it.

Press the up-arrow key 17 times to move the cursor to E8, the first value in the range. Notice how the control panel now says sum(E8

Press . to anchor the range at E8.

Press [END]

Press the down-arrow key. (The range will be highlighted in blue. You do want to sum to the line.)

Type ) to finish the formula.

Press [ENTER] to enter the formula.

The SUM function is probably the most used function. When possible, include an extra row in your SUM range. The extra cell E24 contains a label, a set of hyphens. 1-2-3 gives labels a value of 0. Therefore, including this cell in your range will not affect the value of the SUM function. But, including the cell provides a way to add a new row at the bottom of the column without forcing you to edit the SUM function.

Move the cursor to E27.

- 4. Using the MAX function, find Pam’s high game.

Type MAX(

Press the up-arrow key 19 times to move the cursor to E8, the first value in the range.

Press . to anchor the range at E8.

Press the down-arrow key 16 times to expand the range through E24, the line below the points.

Type ) to finish the formula.

Press [ENTER] to enter the formula.

You may include the extra cell in the MAX range. Hopefully your maximum will be greater than zero.

Move the cursor to E28.

- 5. Using the MIN function, find Pam’s low game.

Type MIN(

Press the up-arrow key 20 times to move the cursor to E8, the first value in the range.

Press . to anchor the range at E8.

Press the down-arrow key 15 times to expand the range through E23, the last value in the range.

Type ) to finish the formula.

Press [ENTER] to enter the formula.

You may not include an extra cell in the MIN range. 1-2-3 will treat the label as a zero point game.

Move the cursor to E30.

- 6. Using the COUNT function, count the number of games Pam played.

Type COUNT(

Move the cursor to E8, the first value in the range.

Press . to anchor the range at E8.

Move the cursor to E23, the last value in the range.

Type ) to finish the formula.

Press [ENTER] to enter the formula.

You may not include an extra cell in the COUNT range. 1-2-3 will treat the label as a zero point game.

- 7. When you have completed entering the formulas, resave the file.