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 ...

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.

Key Takeaways The normal distribution formula is based on two simple parameters—mean and standard deviation—that quantify the characteristics of a given dataset.