Get ConnectEDMeasures of Central Tendency
PART A B C
Multi-Part
Lesson 1GLE 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 497Main 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 15class 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 4IFFUUse =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