Run the appropriate analysis in Excel and then write a short

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:

Solution

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.