Now that we calculated the Expected Counts we need to find the Test Statistic

# Now that we calculated the expected counts we need to

• 20
• 99% (80) 79 out of 80 people found this document helpful

This preview shows page 16 - 19 out of 20 pages.

1.0/ 1.0 PointsQuestion 17 of 20The Test Scores for a Statistics course are given in the Excel below.The data (X1, X2, X3, X4) are for each student.X1 = score on exam #1X2 = score on exam #2X3 = score on exam #3X4 = score on final examYour professor wants to know if all tests are created equal.What is the F-StatSee Attached Excel for Data. Now that we calculated the Expected Counts we need to find the Test Statistic. Test Stat = You will need to all 12 Count values but I am only showing you 3 because there isn't room to write out the entire equation. Part 4 of 4 - F-Distribution and Three or More Means 3.0/ 4.0 Points ? Exam data.xlsx 9 KB A. 4.521 B. 5.532 C. 3.331 D. 4.872 Answer Key: A Feedback: Run a F-Distribution ANOVA analysis using Excel. Data -> Data Analysis -> the first option is Anova: Single Factor -> Click OK In the Input Range: Highlight all 4 columns including the top row with the Labels. Check the box Labels in the First Row and click OK 2/28/2020 APUS CLE : MATH302 B007 Win 20 : Tests & Quizzes 17/20 1.0/ 1.0 Points 1.0/ 1.0 Points If done correctly the F-Stat from the ANOVA output is ANOVA Source of Variation SS df MS F Between Groups 1878.945633 3 626.3152111 4.521 Within Groups 13298.84916 96 138.5296787 Total 15177.79479 99 Question 18 of 20You are conducting a study of three types of feed supplements for cattle to test their effectiveness inproducing weight gain among calves whose feed includes one of the supplements. You have four groups of 30 calves(one is a control group receiving the usual feed, but no supplement). You will conduct a one-way ANOVA after oneyear to see if there are difference in the mean weight for the four groups.IfSSbetween= 369.3 andSStotal= 945.1 for this data.Identify the SSwithin A. 573.4B. 1314.4C. 600.4D. 575.8Answer Key: Feedback:SStotal=SSwithin+SSbetween945.1 =SSwithin+ 369.3 D Question 19 of 20The Test Scores for a Statistics course are given in the Excel below.The data (X1, X2, X3, X4) are for each student. X1 = score on exam #1 X2 = score on exam #2 X3 = score on exam #3 X4 = score on final exam 2/28/2020 APUS CLE : MATH302 B007 Win 20 : Tests & Quizzes 18/20 0.0/ 1.0 PointsQuestion 20 of 20The Test Scores for a Statistics course are given in the Excel below.The data (X1, X2, X3, X4) are for each student. Your professor wants to know if all tests are created equal. Looking at the Summary output, which two Exams have the biggest difference in average? See Attached Excel for Data. Exam data.xlsx 9 KB A. Exam 1 and the Final B. Exam 2 and the Final C. Exam 3 and Exam 1 D. Exam 3 and the Final Answer Key: D Feedback: Run a F-Distribution ANOVA analysis using Excel. Data -> Data Analysis -> the first option is Anova: Single Factor -> Click OK In the Input Range: Highlight all 4 columns including the top row with the Labels. Check the box Labels in the First Row and click OK If done correctly the ANOVA output is SUMMARY Groups Count Sum Average EXAM1 25 1976.00 79.04 EXAM2 25 1987.00 79.48 EXAM3 25 2037.00 81.48 FINAL 25 1755.43 70.22 The Final the lowest average of 70.22% Exam 3 has the highest average of 81.48%  • • • 