A florist determines the probabilities for the number of flower arrangements they deliver each day.
|
Find the mean, variance, and standard deviation of the distribution rounded to 4 decimal places.
Mean =
Variance =
Standard Deviation =
Approximately how many arrangements should the florist expect to deliver each week, rounded to the nearest whole number?
how do you find this using excel?
To find the variance, we FIRST calculate the mean. Then, we can use =SUMPRODUCT((x-mean)^2,probabilities) in Excel to calculate the variance.
The standard deviation is the square root of the variance.
19 | 0.21 | 3.99 | 361 | 75.81 |
20 | 0.23 | 4.60 | 400 | 92.00 |
21 | 0.33 | 6.93 | 441 | 145.53 |
22 | 0.11 | 2.42 | 484 | 53.24 |
23 | 0.12 | 2.76 | 529 | 63.48 |
Get Answers For Free
Most questions answered within 1 hours.