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%
Question 20 of 201.0/ 1.0 PointsThe following data represent weights (pounds) of a random sample of professional football players on the following teams.X1 = weights of players for the Dallas CowboysX2 = weights of players for the Green Bay PackersX3 = weights of players for the Denver BroncosX4 = weights of players for the Miami DolphinsX5 = weights of players for the San Francisco Forty NinersYou join a Fantasy Football league and you are wondering if weight is a factor in winning Football gamesWas is the MSwithin?See Attached Excel for Data.Reference: The Sports Encyclopedia Pro FootballFootball Weight data.xlsx9 KB
A. 428.44