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%