Browse » Home
Saturday, August 11, 2012
How to Make a Frequency Chart
1.
Create a dataset of student grades; include student names and the grades 50, 60, 70, 80, 90 and 100. Enter or sort the grades in ascending order.
2.
Create a bin range of 50, 60, 70, 80, 90 and 100 and enter or sort it in ascending order.
3.
Go to 'Data Analysis.' In older versions of Excel, go to 'Tools,' 'Data Analysis.'
4.
Click on 'Histogram,' then click 'OK.' A frequency chart is also considered a Histogram.
5.
Select the 'Input Range' of the histogram. Click on the box beside the field.
6.
Highlight the 'Input Range' which is the 'Grade' column. Click on the box again to return to the histogram dialog box.
7.
Select the 'Bin Range' of the histogram. Click on the box beside the field and highlight the 'Bin Range' column.
8.
Click on the box beside the field to return to the 'Histogram' dialog box.
9.
Click on the 'Labels' check-box and the 'Output Range' button. The Labels check-box tells Excel that there are labels in the dataset. The Output Range tells Excel where to place that information that will feed the frequency chart or histogram.
10. Select the 'Output Range' using the same steps as the selection of the Input and Bin Ranges. However, select only one cell. In this case, cell E14 was selected. Return to the 'Histogram' dialog box.
11. Click the 'Chart Output' box which will generate the frequency (histogram) chart.
12. Click 'OK' to generate the frequency chart.