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.

 

Transcribed Image Text:

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

Answer rating: 100% (QA)

1 261 259 257 MEAN 143432099 256 STD DEV 678404264 254 COUNT 81 252 25... View the full answer