Can you show me how to do this in excel A population has a mean of 200 and a sta

Question

Can you show me how to do this in excel

A population has a mean of 200 and a standard deviation of 70. Suppose a sample of size 100 is selected and is used to estimate .

What is the probability that the sample mean will be within +/- 4 of the population mean (to 4 decimals)? (Round z value in intermediate calculations to 2 decimal places.)

What is the probability that the sample mean will be within +/- 15 of the population mean (to 4 decimals)? (Round z value in intermediate calculations to 2 decimal places.)

Explanation / Answer

Probability that the sample mean will be within +/- 4 of the population mean

z(196) = (196-200)/70 = -0.057
z(204) = (204-200)/70 = +0.05
P(196 < x < 204) = p(-0.057< z < 0.057) = 0.0478

probability that the sample mean will be within +/- 15 of the population mean

z(185) = (185-200)/70 = -0.214
z(215) = (215-200)/70 = +0.214
P(185 < x < 215) = p(-0.214< z < 0.214) = 0.1664

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

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