image

Appendix D: Histograms Using Excel

image

To facilitate histogram construction, we use the Histogram program in Excel to tally frequencies, calculated percentages, and graph the relative frequencies and cumulative relative frequency. Histogram is in the Data Analysis option of Excel Tools. Before looking for Histogram, verify that Add-Ins includes the Data Analysis option. Add-Ins are also in the Tools option. Histogram is used with the following data to construct a continuous and discrete histogram.

The observations are sampled from a continuous distribution ...

Get Performance Evaluation of Industrial Systems, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.