I found this question that was answered on your website...During the recent prim

Question

I found this question that was answered on your website...During the recent primary elections, the democratic presidential candidate showed the following pre-election voter support in Alabama and Mississippi. State Voters Surveyed Voters in favor of domestic candidate Alabama 800 440 Mssissippi 600 360 a. We want to determine whether or not the proportions of voters favoring the Democratic candidate were the same in both states. Provide the hypotheses. b. Compute the test statistic. c. Determine the p-value; and at 95% confidence, test the above hypotheses. My question is, is there a way for me to use excel to do all of this work for me using furmulas? Thank you.

Explanation / Answer

To calculate using formulas , you can use the following format

Steps Teams Alabama Mississippi Calculation 1 Observed count for democratic vote (fo) 800 600 Data given 2 Count for non democratic vote 440 360 Data given 3 Total votes 1240 960 Step 1 + Step 2 4 Combined proportion 0.636 0.636 Total for the two places in Step1/Total for the two places in Step 3 5 Expected count for democratic vote(fe) 789.091 610.909 Step 3 X Step 4 6 fo-fe 10.909 -10.909 Step 1 - Step 5 7 (fo-fe)2 119.008 119.008 Step 6 raised to the power 2 8 (fo-fe)2/fe 0.151 0.195 Step 7 / Step 5 Chi-square test statistic 0.346 Total for two places in Step 8 Degrees of freedom 1 No of places -1 Significance level 5% Data given Chi-square critical 3.841 From Chi-square table

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

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