Get ConnectED
Measures of Central Tendency
PART A B C
Multi-Part
Lesson 1
GLE 0706.5.4
Use descriptive statistics to
summarize and compare
data. SPI 0706.5.3 Calculate
and interpret the mean,
median, upper-quartile,
lower-quartile, and
interquartile range of a set
of data. Also addresses
GLE 0706.1.8.
Lesson 1C Measures of Central Tendency 497
Main Idea
Use technology to
calculate the mean,
median, and mode of
a set of data.
Spreadsheet Lab:
Mean, Median, Mode
ALLOWANCE Mrs. Jenson’s seventh-grade Allowance Per Week ($)
15 10 11 9 12.50
28 12 10 10 15
class was surveyed about how much
allowance each student receives each
week. The results are shown in the table.
Make a spreadsheet for the data and find
the mean, median, and mode.
Open a new spreadsheet. Create four columns labeled
DATA, MEAN, MEDIAN, and MODE.
#$%
"
4QSFBETIFFUTBNQMF
%"5"
.&"/ .&%*"/.0%&
4IFFU 4IFFU 4IFFU
Use =AVERAGE (A2:A11)
to find the mean.
Use =MEDIAN (A2:A11)
to find the median.
Use =MODE (A2:A11)
to find the mode.
Enter each allowance amount in the DATA column.
In cell B2, enter =AVERAGE(A2:A11). In cell C2, enter
=MEDIAN(A2:A11). In cell D2, enter =MODE(A2:A11).
Each of these will find the mean, median, and mode of
the data set.
the Results
- What data value is an extreme for the set? Explain your reasoning.
- Describe how the measures of central tendency would change if
the extreme value was not included in the data set.
490_497_C09_L1_895130.indd 497 1/11/10 9:31 AM