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

2] To create a bell curve in excel, we need three values, average, standard deviation, and normal distribution. Let’s calculate the average of the data first.