Step 1: Ogen Excel data set MBODYxis found inthe Chapter fokser.Determine the Ma

Question

Step 1: Ogen Excel data set MBODYxis found inthe Chapter fokser.Determine the Margin of Error andthe 95% confisence interval for the male's meight This sample (e 400 be used to the populasion meas (u) for men. Step 2: Detesmine the mean and the staasard deviation the Insest Faaction tool or the Descriptive Statisti:s option te Data Asalysis tool Male Health weight Mean kg. Standard Deviation kg. Step 3: Using the Istasest Faacson and select te CONFIDENCE NORM tool to determine the confiseace levelMargin ofError for your sata sample- (o. 0.03. N Male Health weight Margin of Error kg. Step 4: Use Excel calculate Upper Class Limit Gr aas she Lores Class Lamit(x-E. Male Health weight Upper Class Limit (UCL kg. Lower Class Limit (LCL) kg Step 5: This give you the foloaing confidence interval for the population meas u: Step 5: Explain hat the coafiseace iteral teisus about e men's eight

Explanation / Answer

a)Mean=82.9kg

Standard deviation=18.61

Use the formula =AVERAGE(J3:J42) to get mean, =STDEV.S(J3:J42) to get standard deviation.

b)Use function =CONFIDENCE.NORM(0.05,A42,40)=5.767Kg

c)UCL=82.9+5.767=88.667Kg,

LCL=82.9-5.767=77.133Kg

d)Confidence Interval->77.133<u<88.667

e)Confidence Interval tells us that there is a 95% probability that the mean of the samples lie between 77.133kg and 88.667kg

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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