How to Make a Histogram in Microsoft Excel
Microsoft Excel has the functionality needed for financial, accounting, and statistical functions. Enter any amount of data and Microsoft Excel formulas can quickly generate analysis about the data. In addition, for presentation purposes, Microsoft Excel can generate a pie chart, bar chart, or histogram, just to name a few. A histogram provides a visual representation of the frequency of data. For example, during what hours of the day do most accidents happen on the expressway? A Microsoft Excel histogram can help answer this question. Learn how to create a histogram in Microsoft Excel.
Things You'll Need
- Microsoft Excel
Open Microsoft Excel and go to "Tools", "Add-ins". Place a check in the box beside "Analysis ToolPak", click OK.
Create a table with the following columns: Time of Day, Accidents, & Range. Enter the data in the following image.
Go to "Tools", "Data Analysis" or "Data", "Data Analysis". Click on "Histogram" then click OK.
Click the box beside "Input Range" and highlight the "Accidents" data. Click the box beside "Bin Range" and highlight the "Range" data. The Input Range is the raw data while the Bin Range provides the intervals to separate the data into.
In the "Output Options" select "Output Range". Select an empty cell within the worksheet then press OK. This places the histogram and corresponding table on the same worksheet as the original information.
According to the histogram, the most accidents occur at five hours during the day; when referring to the data table, those hours are 1am, 4am, 2pm (1400 hours), 5pm (1700 hours), and 11pm (2300 hours).
Tips & Warnings
- To change the labels and title of the chart, double-click each label and the title. Drag a corner of the chart to enlarge it.
- Double-check the results against the data to ensure the accuracy of the histogram. Know the question to be answered prior to charting; this will save time.