# Review Exercises

## Objectives

- Practice summarizing data with a frequency distribution.
- Practice summarizing data with a chart.
- Practice summarizing data with descriptive statistics.

For these review exercises, download and open the file
StatisticsReview.xlsx.

## Exercise 1

Each trial in an experiment consisted of flipping eight coins and recording
the number of heads. The experiment included 200 trials with the results
recorded in column A on the "Eight Coins" worksheet.

A. Find the five-number summary, the mean, and the standard
deviation.

B. Generate an ungrouped frequency distribution and a chart illustrating the
frequency distribution. Set the chart title to "Flipping Eight Coins", the
horizontal axis title to "Number of Heads", and the vertical axis title to "Frequency".

## Exercise 2

The data below is taken from a study of 4000 year old Egyptian skulls. The
values are the nasal heights of the skulls measured in millimeters. Enter this
data in column A of the "Skulls" worksheet.

49 48 50 44 54 56 48 48 51 51 50 53 51 50 51 54 50 53 50 49 51 47 53 50 49 55 53 48 54
46

A. Find the five-number summary, the mean, and the standard deviation.

B. Prepare an ungrouped frequency distribution. As has been our custom, enter the label
"n=" at the bottom of the x column and a summation formula at the
bottom of the f column. Make sure the sum of the frequencies corresponds to the
number of skulls in this sample. Create a chart illustrating the frequency
distribution.

## Exercise 3

The worksheet "TV Hours" contains the results of a television viewing study.
The study included three random samples. One sample consisted of grade school children,
the second of college age adults, and third of adults fifty years old or older.
Each subject reported the number of hours of television they watched per week.

A. For each sample, find the five-number summary, the mean, and the standard
deviation.

B. For each sample, generate a grouped frequency distribution based on the
midpoint values indicated. For each sample generate a chart illustrating the
frequency distribution.

To see my solutions, download and open the file
StatisticsReviewDone.xlsx.