You can use the RAND () function to establish probability and create a random variable with normal distribution.

Discover what a log-normal distribution is, its financial applications, and how to calculate it, including using Excel for ...

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.

You can use the Frequency function within Excel in Microsoft Office 2011 for the Macintosh platform to calculate the frequency of data that lies within a certain range.