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

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

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.