Run the appropriate analysis in Excel and then write a short paragraph to answer

Question

Run the appropriate analysis in Excel and then write a short paragraph to answer the question. The paragraph should include:

1. The null and alternative hypothesis
2. The results of your Excel analysis including t-statistics, critical values, and p-values
3. Interpretation of these results
4. Final answer to the question.

Question: Males from the sample were expected to have a FEV of 3.81 L based on their average height and age. Did the male smokers in the sample have an average FEV less than 3.81 L?

Here are the FEV levels for male smokers:

1.694 1.953 2.276 2.304 3.082 3.339 3.343 3.406 3.498 3.688 3.727 3.751 3.799 3.957 4.045 4.07 4.086 4.27 4.309 4.404 4.506 4.637 4.756 4.763 4.789 4.872

Explanation / Answer

Here,

xo = 3.81

x = 3.74

s = 0.79

n= 26

Now,

Null hypothesis : Ho : xo = x

Alternative hypothesis: Ha : xo is not equal to x.

t = (x-xo)/(s/sqrt(n))

t = (3.74 - 3.81) /(0.79/sqrt(26))

t = 6.33

Critical values,

for 0.05 alpha,

tcr = 2.056

So,

null hypotheis can be rejected.

Hence, alternative hypothesis is rejected.

so there is much difference between these two samples.

1.694 1.953 2.276 2.304 3.082 3.339 3.343 3.406 3.498 3.688 3.727 3.751 3.799 3.957 4.045 4.07 4.086 4.27 4.309 4.404 4.506 4.637 4.756 4.763 4.789 4.872 Mean = 3.743231 Sd = 0.791153

Related Questions

Navigate

• Browse (All)
• Browse R
• Subjects

---

---

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