91%(11)10 out of 11 people found this document helpful
This preview shows page 8 - 11 out of 13 pages.
probability of the row and then multiple it by the column total.FreshmenSophomoresJuniorsSeniorsSumYes75885542260No30283840136Sum1051169382396FreshmenSophomoresJuniorsSeniorsYes=105*(260/396)=116*(260/396)=93*(260/396)=82*(260/396)No=105*(136/396)=116*(136/396)=93*(136/396)=82*(136/396)Now that we calculated the Expected Count we can use Excel to find the p-value.Use =CHISQ.TEST(highlight actual counts, highlight expected counts) = 0.00100.0010 < .01,Reject Ho. Yes, it can be concluded that participation in sports is dependent on grade level.Question 12 of 20Click to see additional instructionsThe following sample was collected during registration at a large middle school. At the 0.05 level of significance, can it beconcluded that level of math is dependent on grade level?Honors MathRegular MathGeneral Math6thGrade3547147thGrade3749128thGrade334819Enter the missing values in the expected matrix - round to 4 decimal places.Honors MathRegular MathGeneral Math6thGrade34.285747.020414.69397thGrade354815
1.0/ 1.0 PointsQuestion 13 of 20Click to see additional instructionsA high school runs a survey asking students if they participate in sports. The results are found below. Run an independence testfor the data at α=0.01FreshmenSophomoresJuniorsSeniorsYes75885542No30283840Enter the test statistic - round to 4 decimal places.8thGrade35.714348.979615.3061.Feedback:We are running a Chi-Square Test for Independence. Copy and Paste the table into Excel. You are given the Observed Counts in the table.Next you need to sum the rows and columns. Once you have those you need to calculate the Expected Counts.You need to find theprobability of the row and then multiple it by the column total.FreshmenSophomoresJuniorsSeniorsSumYes75885542260