The marks are out of 100. 2] To create a bell curve in excel, we need three values, average, standard deviation, and normal distribution. Let’s calculate the average of the data first.

In Excel, syntax for this function is NORMINV(probability,mean,standard deviation). Using the sales example ... probability and create a random variable with normal distribution.

From that calculation you can then create a graph which shows the frequency distribution ... How to Put a Gaussian Curve on a Graph in Excel. Gaussian curves, normal curves and bell ...