Alternatively, the Real Statistics Histogram with Normal Curve Overlay data analysis tool can be used. This is the approach illustrated in Example 4 of Frequency Tables using the FREQTABLE supplemental function.

To avoid this problem equally-spaced intervals can be used. Otherwise, a distorted picture of the data may be presented. For most purposes, it is important that the intervals be equal in size (except for an unbounded first and/or last interval). Figure 2 – Histogram data analysis tool CautionĬaution must be exercised when creating histograms to present the data in a clear and accurate way. You can optionally include the labels for these ranges (in which case you check the Labels check box).įor Example 1, the Input Range is A4:B14 and the Bin Range is D4:D7 (with the Labels check box unchecked). In the dialog box that is displayed you next specify the input data (Input Range) and bin array (Bin Range). Excel Data Analysis ToolĮxcel Data Analysis Tool: To use Excel’s Histogram data analysis tool, you must first establish a bin array (as for the FREQUENCY function described in Frequency Tables) and then select the Histogram data analysis tool. You can use Excel’s chart tool to graph the data in Figure 1, or alternatively, you can use the Histogram data analysis tool to accomplish this directly, as described next. We start by replicating the data and bin section for Example 1 in Figure 1. A histogram is a graphical representation of the output of the FREQUENCY function (as described in Frequency Tables).Įxample 1: Create a histogram for the data and bin selection for Example 1 from Frequency Tables.

How to create histogram in excel