Solve the following problems using Excel - Where applicable, make sure to state

Question

Solve the following problems using Excel - Where applicable, make sure to state the null and alternative hypotheses - Make sure I am able to see any Excel function you use to make a calculation - Use both methods (rejection region and p-value) for each problem - Make sure everything is clearly labeled - To type your answers in Excel, click “Insert” then click “Text box” and specify the location of the text box inside the Excel worksheet - The Excel file should have 3 sheets (one sheet per problem)

In a study of childhood asthma, 4317 observations were collected on education level and smoking during pregnancy. At = 0.01, is smoking during pregnancy independent of education level? Smoking During Pregnancy pack Education Level | No smoking |

Explanation / Answer

Ans:

H0:Smoking during pregnency is independent of the education level.

Ha: Smoking during pregnecy is not independent of the education level.

Expected count is calculated as:

Expecetd count=row sum*column sum/overall sum

df=(4-1)*(3-1)=3*2=6

critical chi square=CHIINV(0.01,6)=16.812

p-value=CHIDIST(227.78,6)=0

As,p-value<0.01,we reject null hypothesis.

critical value approach:

chi square test statistic=227.78>16.812,we reject null hypothesis.

There is sufficient evidence to conclude that smoking during pregnency is independent of the education level.

Observed(O) No smoking <1/2 pack > 1/2 pack Total <high school 641 196 196 1033 High school 1370 290 270 1930 some college 635 68 53 756 college 550 30 18 598 Total 3196 584 537 4317 Expected(E) No smoking <1/2 pack > 1/2 pack Total <high school 764.76 139.74 128.50 1033 High school 1428.83 261.09 240.08 1930 some college 559.69 102.27 94.04 756 college 442.72 80.90 74.39 598 Total 3196 584 537 4317 chi square=(O-E)^2/E No smoking <1/2 pack > 1/2 pack <high school 20.03 22.65 35.46 High school 2.42 3.20 3.73 some college 10.13 11.48 17.91 college 26.00 32.02 42.74 Total chi square score=227.78

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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