Probability distributions are used to predict various aspects of the business. The normal distribution has wide applications in business and can be used to calculate the probability of sales, the number of customers to expect in a given week, employee performance, and operations, to name a few. In cell B2, calculate the probability of selling the exact number of products calculated in cell A2, using the normal distribution function and the mean and sample standard deviation calculated in the prior step.

 

383 1 2 3 1 5 5 7 B 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 A Sales Volume X fx B Probability 0.998736662 0.99871435 0.9986919 0.998680625 0.99865798 0.998635213 0.998635213 0.998623786 0.998554672 0.998484757 0.998473042 0.998331561 0.999975966 0.999854611 261 259 257 256 254 252 252 251 245 239 238 226 225 215 209 #NUM! 209 #NUM! 209 #NUM! 204 #NUM! 195 #NUM! 191 #NUM! 191 #NUM! 191 #NUM! 189 #NUM! 188 #NUM! 187 #NUM! 187 #NUM! 184 #NUM! #NUM! 182 SalesVolume Tickets Forecast Documentation D + E F Mean Std Deviation Quantity 4 G 143 67.84043 81 H I J K L U