Lab 3 Frequency Tables and Histograms

You will construct a histogram with 5 classes (bars) using Excel. Graphing a histogram manually requires determining minimum and maximum values in a data set, class width, the lower and upper limits of classes of values, class boundaries, midpoints, etc. This is similar in Excel. You will need the upper-class limits and the midpoints for adjusting the graph created with Excel.

Throughout this manual, Select means to left-click with the mouse/pad.