7] Now, click on the “ All Charts ” tab and go to “ XY Scatter > Scatter with Smooth Lines.” Here, select the “ Normal Distribution ” chart and click the “ OK ” button.

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

In Excel, syntax for this function is NORMINV (probability,mean,standard deviation). Using the sales example, with a weekly sales average of $2,000 that fluctuates about $500 up or down, you know ...