Here, well walk you through the process of creating a bell curve in Excel.
Youll notice that it gives a value of 53.93.
To do so, punch in:
Now the mean becomes 54.
Since you have the complete data i.e.
marks of all the students in the class, well useSTDEV.P.
To get the standard deviation of the given mark sheet, pop in:
Youll get 27.755.
Lets first find the normal distribution of all the values inside the dataset:
1.
Finding Normal Distribution
Its time to calculate the normal distribution of the data points.
That’s because the dataset (student’s marks) is not normally distributed (i.e.
the mean, median, and mode of the dataset are not the same.)
you’re free to apply the same process to create a bell curve for any given data.
