John P. Crotty
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
|
———
|
-
2. Let’s see how many games Pam scored above her average and how many games Pam scored below her average.
Move the cursor to F8.
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.
