9:54 PM The folowing tabie recerds the weight On pounds) of each rower on the 20

Question

9:54 PM The folowing tabie recerds the weight On pounds) of each rower on the 2008 U.S. Olymoic men's rowing team A dotpiot weights felows Weight 200 205 Weight Name 216 Hoopman 161 ovey Double Soulls 194 209 218 121 229 159 209 Inman tight 220 Lanzone Fur Daly 209win Quad Sculs 154 Todd Lw four 205 vopenhein eour 220 205 wlish 225 Winklevoss, C. Quad Sculls 200 Winklvoss, T.Pair 181 Schnobrich Eight 209 Quad Soulls Quad Sculls 120 140 160 180 220 Weighs (pound Round your anewers to two decimal places Determine the mean and standard devation of these weights. Mean Standard Deviation b. How many standard deviations below the mean is the weight of the coxswain (McElhenney, who weighed 121 pounds)? Enter a positive value in the answer field J standard deviations c. How many standard deviations above the mean is the weight of the heaviest rower (Newin, who weighed 229 pounds)? standard deviations d. For a rower to be as many standard deviations above the mean as the coxswain is below the mean, how much wouid he have to weigh?

Explanation / Answer

Solution A:

find mean uing average function in excel as

=AVERAGE(A2:A26)

find standard deviation using stddev.s function in excel as

=STDDEV.S(A2:A26)

Solutionb:

find z score

z=x-mean/sd

x=121

mean=197.96

sd=26.8863

z=121-197.96/26.8863

z =-2.86242

negative z score means

2.86242 standard deviations

Solutionc:

For x=229

Z=x-mean/sd

=229-197.96/26.8863

Z =1.154491

it is 1.154491 standard deviations above mean

1.154491 standard deviations

MEAN 197.96 STANDARD DEVIATION 26.8863

Related Questions

Navigate

• Browse (All)
• Browse 9
• Subjects

---

---

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