3.4 Creating the Histogram

  1. Select Data>Data Analysis>Histogram and click OK.

Note: If Data Analysis does not appear in the Data menu, refer to the instructions in Lab 1 Getting Started with Excel how to make it available.

  1. In the dialog window, first click in the Input Range field then type in $A$2:$A$33.

Note: Instead of typing, you can select cells that form the Input Range by clicking on A2, holding, and dragging downward until you reach cell A33. Then release.

    1. Click the Bin Range field in the dialog window first, then type in $D$8:$D$12.

Note: You can also select cells containing the upper limits instead of typing‼!

  1. You have the option to have the graph placed in a specific cell or range of cells (for this option check Output Range as in the picture above, you may select a different cell address) or in a new worksheet (for this check option New Worksheet Ply).
  2. In the pop-up window, Check the boxes for Cumulative Percentage and Chart Output.
  3. Then click OK.
A screenshot showing the dialog window with histogram options.

Figure 3.3: Dialog window with the histogram options.

After the steps above, Excel presents a frequency table and the corresponding graph. Excel counts the frequency of each class based on the Bins values you entered in the dialog window for the histogram. Thus, it counts how many values are in the date set (Input Range) up to the upper limits.

The graph is a raw histogram that needs to be adjusted to resemble an actual histogram.

A screenshot showing the resulting histogram graph.

Figure 3.4: Resulting histogram.