Freshmen Sophomores Juniors Seniors Sum 55 42 260 No 30 28 38 40 136

Freshmen sophomores juniors seniors sum 55 42 260 no

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 Math Regular Math General Math 6 th Grade 34.2857 47.0204 14.6939 7 th Grade 35 48 15
Image of page 8
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. 8 th Grade 35.7143 48.9796 15.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
Image of page 9
1.0/ 1.0 Points
Image of page 10
Image of page 11

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture