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

Select "Normal" from the "Distribution" drop-down list, and then enter "2000" for Mean and "500" for Standard deviation. Click the "Output Range" button, and then enter "C2" in the parameter box.

The normal distribution formula is based on two simple parameters—mean and standard deviation—that quantify the characteristics of a given dataset. To facilitate a uniform standard method for ...