EXCEL

How to Create a Histogram in Excel from WikiHow is available under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 United States license. © WikiHow. UMGC has

modified this work and it is available under the original license.

Creating the Histogram

Enter your data. Organize your data into two adjacent columns on the spreadsheet. Fill the left-hand column with your input data, and the right-hand column with your bin numbers.

Input data is the set of numbers that you want to analyze with the Histogram tool. Bin numbers represent the intervals that you want the Histogram tool to use for measuring and analyzing the input data. For instance, if you want to separate grades into categories of A, B, C, D, and F, you could make bins for 60, 70, 80, 90, and 100.

1

Open the Data Analysis box. The process is consistent for all versions of Excel released since 2007. If you are using an earlier version of the software, then you will need to follow a slightly different process.

In Excel 2013, Excel 2010 and Excel 2007: navigate to the Data tab. Then, click Data Analysis in the Analysis group. For Excel 2003 and earlier versions: select Data Analysis from the Tools menu. If there is not a Data Analysis option under the Tools menu, then you may need to install the add-in.

2

Select Histogram. Once you're in the Data Analysis dialog box, find Histogram listed amid the other analysis tools. Then click OK. This will open the Histogram dialog box.

3

Select the input range and the bin range. The input range is the range of cells that contain data. If your input data is a set of ten numbers, and you have copied it into the A column (from A1 to A10), then enter your data range as A1:A10. The bin range is the range of cells that contain your bin numbers. If you have four bins at the top of Column B, then enter your bin range as B1:B4.

4

Check the chart output box. Under Output Options, click New Workbook. Then select the Chart Output check box.

5

Click OK to finish the job. Excel will generate a new workbook with a histogram table and an embedded chart. The chart should be a column chart that arranges the data from your histogram table.

Tips

By default the output is placed into a new worksheet. You can keep the output in the same worksheet by selecting the output range.

Check out the website to download a simple template to

create histograms. Note that a frequency table is also

created.

Warnings

Be careful to understand what the bins mean. The bin range should not be

confused with the data.

Make sure your histogram makes sense before drawing any conclusion from

it.

Sources and Citations 1. https://support.microsoft.com/en-us/kb/214269 2. http://www.excel-easy.com/examples/histogram.html 3. https://support.office.com/en-us/article/Create-a-histogram-B6814E9E-5860-4113-BA51-

E3A1B9EE1BBE

6

4. http://www.math.kent.edu/~honli/teaching/statistics/Chapter2/Excell_Histogram.html 5. https://www.ncsu.edu/labwrite/res/gt/gt-bar-home.html 6. https://support.microsoft.com/en-us/kb/214029`