View the step-by-step solution to:

Question

# Use the following information to answer Questions 1-4. Use Excel to compute answers.The

number of raisins in a 24 oz. box of Raisin Bran Cereal is normally distributed with a mean of 100 raisins and a standard deviation of 15 raisins.

1)   What is the probability that a box of cereal will have no more than 110 raisins in it?

A.   0

B.   0.75

C.   0.68

D.   0.83

2)   What is the probability that a box of cereal will have between 80 to 120 raisins?

A.   0.5

B.   0.32

C.   0.67

D.   0.82

3)   Help the manager decide the raisin count per box for the top 3% boxes with respect to the raisin content. In other words, how many raisins must be in a box so that the box is in the top 3% with respect to raisin content? Pick the answer that comes closest to the correct answer.

A.   More than 106

B.   More than 112

C.   More than 128

D.   More than 142

4)   Assume the manager wants 0.9 probability that a box of cereal has 60 or more raisins. Also assume that the process remains normally distributed and the standard deviation of process remains the same (i.e., 15 raisins). What should be the mean of the number of raisins in a box of cereal? Round off to nearest integer.

A.   79

B.   85

C.   95

D.   105

1) Result is 0.75 2) Result is... View the full answer

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents