You're analyzing a dataset and would like to create a histogram plot of the data showing its frequency distribution.
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-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, ...