Friday, November 01, 2013

How To... Draw a Simple Histogram in Excel 2010

An essential ability for anyone analysing data to have is to be able to draw a Histogram. Not to be confused with a Bar Chart, a histogram is a chart (usually a simple column chart) that takes a collection of measurements and plots the number of measurements (called the frequency) that fall within each of several intervals (called bins). It is the frequency and bins that you need to draw the histogram.

In my latest video I show how to draw a histogram with Excel's Data Analysis Add-In. The example data I used are the grades of students who took an exam. Here is the video from YouTube:

No comments:

Post a comment