should you have any doubts. Excel Tips: Go to Formulas/More Functions/Statistica

Question

should you have any doubts. Excel Tips: Go to Formulas/More Functions/Statistical/Select one for the options below: DIST gives the probability that a number falls at or below a given value of a normal distribution. NORM.DIST(x, mean, standard deviation,cumulative) NORM.S.DIST function translates standard deviations (2) into cumulative probabilities. (Z Score, cumulative) 4. A garment manufacturing company in Downtown Los Angeles has 550 hourly employees with an average age of 25.5 years, and a standard deviation of 4.5 years. If a random sample of 50 hourly employees is taken, what is the probability that the sample will have an average age of more than 25 years old? (Hint: Uses Norm.Dist) 5. Forty-Six percent of a population possesses a particular characteristic. Random samples are taken from this population. Determine the probability for: sample size 60 and the sample proportion is between 41 and.53 (Hint: Use Norm.S.Dist)

Explanation / Answer

4)

You can solve it directly throgh function : =1-norm.dist(25,25.5,4.5/sqrt(50),true)

5)

You may use from excel =NORM.S.DIST(1.0879,TRUE)-NORM.S.DIST(-0.7771,TRUE)

for normal distribution z score =(X-?)/? here mean=       ?= 25.5 std deviation   =?= 4.5 sample size       =n= 50 std error=?x?=?/?n= 0.6364

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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