With that, Excel can generate a series of random numbers based on the data entered and the standard deviation. With this data you can then create a curved chart, known as a bell curve.

If you know your data mean and its standard deviation, you can use the random number generator from the Excel Analysis ToolPak add-in or your own statistical data to chart a Gaussian curve.

Function : Calculate the standard deviation based on the entire sum can be provided in the form of argument. Standard deviation is a measure of the dispersion of the value for the average value.