How to Create a Frequency Histogram in Excel
Microsoft Excel is a spreadsheet program that allows users to create, among other things, a frequency histogram. A frequency histogram is a graph that shows the number of occurrences of certain events, categories or scores. Histograms differ from bar graphs because the categories must be sequential. For example, you could make a histogram of grades because the numerical grades are sequential but you could not make a histogram of pet types because cats, dogs and hamsters and not sequential.
Type the title of your data in cell A1 and enter your data below it. For example, if you were creating a frequency histogram of grades on a test, you would type "Grades" in cell A1 and then type the numerical grades in the cells below.
Enter the bin values that you want to use in a separate column. The bins are the values that will be grouped together. For example, if your grading scale was: 90 and up is an A; 80 to 89 is a B; 70 to 79 is a C; 60 to 69 is a D, and 59 and below is an F, you would enter 59, 69, 79, and 89.
Select the "Data Analysis" option from the Data tab then select "Histogram." Enter the cells that you typed your data in, for example A2:A19, into the "Input Range" and then enter the cells that you typed your bins into the "Bin Range."
Chose whether to have the histogram appear as an item in the existing spreadsheet or on its own in a new sheet then click "OK." The histogram will show up where you have specified.