Now that we calculated the expected counts we need to

1.0/ 1.0 Points
Question 17 of 20
The 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
Your professor wants to know if all tests are created equal.
What is the F-Stat
See 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 20
You are conducting a study of three types of feed supplements for cattle to test their effectiveness in
producing 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 one
year to see if there are difference in the mean weight for the four groups.
If SS
between
= 369.3 and SS
total
= 945.1 for this data.
Identify the SS
within
A. 573.4
B. 1314.4
C. 600.4

D. 575.8
Answer Key:
Feedback:
SS
total
= SS
within
+ SS
between
945.1 = SS
within
+ 369.3
D
Question 19 of 20
The 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 Points
Question 20 of 20
The 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%