hwahomes.blogg.se - How to create histogram in excel

In the Output Range box, enter the cell that you want to display the frequency distribution table that will be created by the histogram tool.

For the Bin Range, select the interval values entered in step 1.

In this example that is the school grades in B4:B23.

For the Input Range, select the range of cells containing the data that you want to chart.

Select the Histogram tool and click OK.

If you cannot see the Data Analysis button, then the Analysis Toolpak has not been installed.Ĭlick the Add-Ins button on the Developer tab, check the Analysis Toolpak button and click OK to install it (Having trouble? Watch this video on how to install the Analysis Toolpak add-in).

Click the Data tab, and then the Data Analysis button.

for 60-70, enter 70.īin values have been entered in the range D4:D8 in the example below. This will be the upper value of the interval e.g.

To create a histogram in Excel, you first need to enter the bin values (interval ranges) that you want to use.

For example, the histogram below displays the distribution of school grades from 20 pupils among different intervals.