While Excel still doesn't have an automatic formula for calculating a dataset’s z-score, we can use other Excel formulas to calculate the mean and then the standard deviation. The entire process may ...

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.

Learn how to calculate Standard Deviationin Excel. The STDEV function can be used to estimate standard deviation based on sample in Excel.

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.