Here, Bin 65 has 1 frequency which means from 60 to 65, they have found one mark of a particular student.

It will give us the following output where it shows the bin we assigned previously and the frequency of distribution of our dataset.

Then, set the Output options in the current worksheet.

Next, select the Bin Range that we created above.

Here, we take the Marks column as the Input Range from cell C5 to cell C20.

In the Histogram dialog box, select the Input Range.

From the Analysis Tools section, select Histogram.

A Data Analysis dialog box will appear.

Next, select Data Analysis from the Analysis group.

We set a bin range by studying our dataset’s lowest and highest values.

To use the Data Analysis Tool, you need to have a Bin range.

From the Add-ins available section, select Analysis Toolpak.

An Excel Options dialog box will appear.

To do this, go to the File tab in the ribbon.

First, you need to enable the Data Analysis Tool.

To do this, we have to follow the step very carefully, otherwise, you don’t create a histogram with a bell curve in Excel. We take a dataset that includes some students and their marks.Īt first, we make a histogram with this dataset and then include a bell curve by calculating the normal distribution. Our first method is based on the student marks. Histogram with Bell Curve for Student Marks Both of the methods are applicable for histograms and bell curves.ġ. Our two example is based on student marks and project completion days. These two examples will give you a proper overview of this matter. Read More: How to Create a Bell Curve with Mean and Standard Deviation in ExcelĢ Suitable Examples to Create a Histogram with Bell Curve in ExcelĪs we want to represent a histogram with a bell curve in Excel, we will show two different examples to create a histogram with a bell curve in Excel. Basically, the bell curve will represent the dataset in a way where it shows how the mean value is above the rest of the values. Finally, 99.7% of the distribution is within the three standard deviations of the mean. Whereas 95.5% of the distribution is within the two standard deviations of the mean. The bell curve feature indicates that a 68.2% distribution is within one standard deviation of the mean value.

In every condition, mean conditions have the better number so the bell curve provides the highest in the middle.

The bell curve will distribute the values evenly. The highest point of the bell curve denotes the most probable condition of the dataset which means the mean values of the dataset. This curve defines the normal distribution of the dataset. The bell curve can be defined as a curve similar to a bell shape.

Make a histogram excel