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.

Following up on that, of course, calculating statistical measures such as standard deviation and correlation manually can be cumbersome.

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