The demand for soda bottles at a particular show is either 30, 40, 44, 60 or 55

Question

The demand for soda bottles at a particular show is either 30, 40, 44, 60 or 55 with probabilities of 35%, 30%, 20%, 10% or 5% respectively. Assume the following random number have been generated: 23, 28, 30, 35, 21, 19, 70, 64, 53 and 76.

Using these numbers, set up an Excel spreadsheet that generates soda bottle demand for 10 days. What is the average demand for soda bottles for these randomly generated numbers?

    (Note: Please submit the spreadsheet with your solution.) Can you explain your answer.

Explanation / Answer

from distribution model

average demand /day =40.05

from randomely generated numbers

average demand /per day is 41.9

which is with in close approximation from probability model. HEnce above randomly generated demand does follow the probability distribution

x P(x) xP(x) 30 0.35 10.5 40 0.3 12 44 0.2 8.8 60 0.1 6 55 0.05 2.75 Total 40.05

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.