Microsoft Office Tutorials and References
In Depth Information
A histogram is a chart (usually a simple column chart) that takes a collection of
measurements and plots the number of measurements (called the frequency ) that fall within each of
several intervals (called bins ).
To demonstrate how the Histogram tool works, we’ll use a table of 1,000 test scores. (The
input range must contain numeric data only.) To see a breakdown of the total scores
at 50-point intervals, begin by setting up the distribution bins shown in column F of
Figure 17-8 Column F contains the distribution bins.
The distribution bins don’t have to be equally spaced like the ones in Figure 17-8 are, but
they must be in ascending order. Click the Data Analysis button on the Data tab, select the
Histogram tool, and then click OK. Figure 17-9 shows the Histogram dialog box.
The Histogram tool can take three items of information: the location of the data (in this
case, $D$2:$D$1001), the location of the bins ($F$2:$F$23), and the upper-left cell of the
range where you want the analysis to appear ($G$1). After you click OK, Excel pastes the
analysis report in columns G and H, as shown in Figure 17-10.