Question

Croissant Bakery offers special decorated cakes for special occasions. It also has regular cakes in its bakery. The following table gives the total number of cakes sold per day and the corresponding probability. Use Excel to find the standard deviation for the sales per day. Round to 2 decimal places. Number of cakes sold Probability Sales $ 12 0.25 420 13 0.40 390 14 0.25 549 15 0.10 605

Answer 1

(x - ) (x - )~P(x) Solution: The probability distribution table can be constructed as below: Number of Probability Sales XP(x) Cakes Sold P(x) x 12 0.25 420 105.00 0.40 390 156.00 14 0.25 549 137.25 15 0.10 605 60.50 xP(x) = 458.75 13 1501.563 4726.563 8145.063 21389.06 375.391 1890.625 2036.266 2138.906 2P(x) = 6441.188 (x - Standard deviation for the sales per day = 0 = (x - u)2P(x) = V6441.188 = 80.26