Here, I want to see how many students get marks below 40, also between 41 to 50, 51 to 60, 61 to 70, 71 to 80, and more than 81.
This means you should write the values about what interval you want to make the Histogram. Here, I will calculate the frequencies in Step 1 and I will show you how to insert a chart in Step 2. Basically, I will find out the frequencies with the FREQUENCY function and then plot a simple bar graph for creating the Histogram. Here, you can use the FREQUENCY function to make a Histogram with two sets of data in Excel. Use of FREQUENCY Function to Make a Histogram with Two Sets of Data Now, let’s calculate how many students get marks between different intervals. In addition, for your better understanding, I’m going to use a sample dataset. Here, I will describe 4 methods to make a Histogram in Excel with two sets of data. Bins are actually classes or intervals.Ĥ Methods to Make a Histogram in Excel with Two Sets of Data Furthermore, you will see a term named Bins here. Here, the rectangle’s width denotes a certain range as intervals and the height of the rectangle denotes the number of frequencies. Creating Histogram with Two variables.xlsxĪ Histogram is a chart that contains some rectangles.
