Use Excel’s Data Analysis toolpak to create a pristine histogram

A histogram is a graph that shows the frequency of numerical data using rectangles. The height of the rectangle (vertical axis) represents the distribution frequency of a variable (the amount or how often that variable appears). Histograms are used to summarise discrete or continuous data that are measured on an interval scale. It is often used to illustrate the major features of the distribution of the data in a convenient form.

A histogram in Excel is a graphical representation that organises and displays the distribution of a dataset. It groups data into bins and counts the number of data points that fall into each bin, providing a visual summary of the data’s distribution.

Excel has a Data Analysis toolpak that can create a histogram. In order to demonstrate how to create a histogram using the Data Analysis toolpak, I have obtained a dataset of salaries, as seen below:-

I calculated a few statistics on the salaries of the dataset.

In cell F2 I used the MAX function to determine that the highest salary id 24,100:-

In cell F3 I used the MIN function to determine that the lowest salary is 4,000:-

I then determined that the bins would range from 4000 to 2500 at intervals of 500, placing the values in column G of the worksheet:-

I then selected the Data Analysis toolpak from the Data tab of the ribbon:-

A pop-up menu came up on the screen and I selected Histogram and clicked on the OK button:-

Another pop-up menu came on the screen and I selected the Input Range and the Bin Range, which have labels.

I selected the output range as being on the same page. I then selected the Chart Output…