You're analyzing a dataset and would like to create a histogram plot of the data showing its frequency distribution.

Use Excel's `FREQUENCY`

function to compute the frequency of occurrence of each data point and use Excel's charting features (see Chapter 4) to create the histogram plot. Or use the Histogram tool in the Data Analysis add-in to compute the frequencies of occurrence and then use Excel's plotting features.

Figure 5-4 shows a histogram plot (bar graph) along with a frequency polygon (the thin line) and cumulative frequency plot (the bold line) for a set of data. The dataset for this example plot represents the angular response of a torsional spring.

You can quickly create this sort of chart using the techniques discussed throughout Chapter 4. You'll first have to compute the actual frequency distribution for your dataset, and to that end you have two choices in Excel: the `FREQUENCY`

function or the Histogram tool included in the Data Analysis add-in.

Figure 5-5 shows a portion of a spreadsheet containing the data used for the histogram plot shown in Figure 5-4.

Figure 5-4. Histogram plot

The angular response data contained in column A is the original dataset for which frequencies are computed. Before applying the `FREQUENCY`

function, you must set up a range of discrete bin values, called *bins*. The bins form bands, ...

Start Free Trial

No credit card required