4 Copy of HW02Probability,914691097-Excel Insert Draw Page Layout Formulas Data

Question

4 Copy of HW02Probability,914691097-Excel Insert Draw Page Layout Formulas Data Review View Tel me what you want to do % Cut Copy . Formatting Table Clipboard Alignment 85 4. Exercise 4 86 A pear sorting process yields pears with mean mass of 200 g and standard 87 deviation of 18 g Sets of 5 pears are put in each bag and sokd as 1 kg mean standard deviation 200 18 89 91 a What proportion of bags are expected to have less than 950 g? [10) 1000 1620 P(Y 950)0.10707033 mean bag weight 94 variance of bag weight 95 96 98 , b. What proportion of bags are expected to have more than1 075 g? 00 variance of bag weight 01 02 03 04 05 06 c What is the central range of values that contains 95% of the average mass of bags with 5 pears [10] P(Y- 1075) 096879629 DOLL

Explanation / Answer

a) Mean bag weight= "=5*E88"
Variance of bag weight= "=5*(E89^2)"

P(Y < 950) = "=NORM.DIST(950, B93, sqrt(B94), TRUE)"

Type in the formulas given between double quotes.

NORM.DIST is used to find probability of normal distributions.

This question is related to the addition of random variables. Independent random variables. This means that thesum of two independent normally distributed random variables is normal, with its mean being the sum of the two means, and its variance being the sum of the two variances.

Your answers are right and variance in part B will be same as part A.

Related Questions

Navigate

• Browse (All)
• Browse 4
• Subjects

---

---

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