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

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.

For example, if you want to show a frequency distribution for every 10 units you would need to define that for Excel. The Frequency function refers to this limit as the "Bin Array." ...