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

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