Variance has been washed away completely. Every number was placed in the same bin because I made it far too large for the data. The trick is that I've only created one bin - in this case for numbers from 0 to 100. For instance, this is a histogram of the above data: You see, any program that will just make you a histogram all willy-nilly is making some choices for you, and those choices basically manifest in how many bars you get on the graph that is created. The first is Excel's 'Frequency' function, and the second is the conceptual act of binning (not to be confused with Dr. We're going to rely on two main concepts today. For that matter, with what Google Docs gave you (for free!). =)Īnyway, we're not here for that today, because we don't need that - you can make your own histograms perfectly well just with what excel gave you. To be fair, I'm also trying to get some money out of you, I'm just a lot worse at it. Many of these sites are trying to get some money out of you. Now, if you do a search of 'how to make histograms in excel' most of the responses will come up with a whole bunch of proprietary junk that builds you histograms if you buy and/or download it, with the remainder suggesting that you find your Excel CD to load a whole bunch of extra packages. If you remember, these numbers should be drawn from a normal distribution with a mean of 50 and a standard deviation of 15.
