Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 4 Describing Your Data 139

3 Click the Chart Options dialog tab.

4 Click the Values button and then click the Use Range References

button. Select the range G1:G20 in the Price Table with Bins work-

sheet. Click the OK button.

5 Click the Right option button to control how bin counts are deter-

mined. See Figure 4-6.

Figure 4-6
Specifying
bin options

for the

histogram

6 Click the Input dialog tab to view other options for the histogram.

7 Click the Output button.

8 Verify that the As a new chart sheet option button is selected and

then type Price Histogram in the accompanying text box.

This will send the histogram to a chart sheet named Price

Histogram.

9 Click the OK button.

Figure 4-7 shows the completed Histogram dialog box. Note that this

command allows you to create histograms of the frequency, cumula-

tive frequency, percentage, or cumulative percentage. In most cases,

histograms display the frequency of a particular variable.