This is one time when I don’t recommend that you filter the data. I then deleted the blank entries at the very top. To make a histogram in Excel, I started by first copying the column of data I want into a fresh sheet of data. You’ll know it worked because the “Data Analysis” section should pop up under the Data tab in Excel on the far right. Next, click “Go”where I circled and make sure you have the ToolPak box checked off. In Excel go to File -> Options and find the add-ins section. (Confused? Don’t worry this is one of those things that makes a lot more sense once you see it.)īefore you make a histogram in Excel,make sure you enable the ToolPak add-in. In other words, it gives us the “shape” of the data. Unlike line graphs and bar graphs which demonstrate a relationship between two variables, a histogram illustrates the frequency distribution for one, numeric variable. Histograms round out what I would consider the most commonly encountered graphs.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |