Supplementary Problem 2.13 (p. 43)
Construct a histogram, a frequency polygon and an ogive

Relative Cumulative
Class Interval Frequency Class Midpoint Frequency Frequency
50-60 13 56.5 0.105691057 13
61-70 27 74.5 0.219512195 40
71-80 43 92.5 0.349593496 83
81-90 31 96.5 0.25203252 114
91-100 9 95.5 0.073170732 123
123

Relative frequency is the same as proportion. You calculate it by dividing the frequency by the total number of observations.
I put the relative frequencies in the chart above.

To calculate a histogram in Excel, go to Insert, then to Chart, then to column.
The "values" will be the frequencies, and the "x-axis labels" will be the class intervals.
You can edit the histogram below to add a title or take away the box that says "series 1" if you want.

A frequency polygon is a graph made by plotting points with an x-coordinate that is the class midpoint and a y-coordinate that is the frequency, then connecting the points by lines.
You could make this by drawing lines between the tops of the histogram bars above.
To make a frequency polygon in Excel, go to Insert, then Chart, then to Line.
The "values" will be the frequencies and the "x-axis labels" will be the class midpoints.

An ogive is the graph of a cumulative distribution function. You put the cumulative frequency on the y-axis.
Make this graph just like you made the frequency polygon, only instead of using the frequencies as the "values", use the cumulative frequencies.

please see the attached graph.