B.
San Francisco 49ers and Miami Dolphins
C. Denver Broncos and San Francisco 49ers
D.
San Francisco 49ers and Green Bay Packers
Answer Key:
C

1.0/ 1.0 Points
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 5 columns including the top row with the Labels.
Check the box Labels in the First Row and click OK.
If done correctly you should get,
SUMMARY
Groups
Count
Sum
Average
Variance
Dallas Cowboys Wt.
17 4202
247.18
235.28
Green Bay Packers Wt.
17 4267
251.00
291.63
Denver Broncos Wt.
17 4323
254.29
263.60
Miami Dolphins Wt.
17 4234
249.06
281.06
San Fran. 49ers Wt.
17 4094
240.82
288.53
Denver Broncos have the highest weight sum and average.
San Francisco 49ers have the lowest weight sum and average.
Question 18 of 20
The
F
Statistic from an experiment with
k
= 3 and
n
= 75 is 2.99. At
α
= 0.05, will you reject
the null hypothesis?

8/30/2020
APUS CLE : MATH302 B011 Sum 20 : Tests & Quizzes
D

18/20
1.0/ 1.0 Points
Question 19 of 20
The following data represent weights (pounds) of a random sample of professional football players on
the following teams.
X1 = weights of players for the Dallas Cowboys
X2 = weights of players for the Green Bay Packers
X3 = weights of players for the Denver Broncos
X4 = weights of players for the Miami Dolphins
X5 = weights of players for the San Francisco Forty Niners
You join a Fantasy Football league and you are wondering if weight is a factor in winning Football games.
At a 5% level of Significant, determine if the weights of football players on each of these teams is same or different?
See Attached Excel for Data.
Reference:The Sports Encyclopedia Pro Football
Football Weight data.xlsx
9 KB
A.
Reject Ho.
The football player's weights for each team are differnt because the p-value = 0.1890
B.
Do Not Reject Ho.
The football player's weights for each team are the same because the p-value =
0.0472
C. Do Not Reject Ho. The football player's weights for each team are the same because the p-value = 0.1890
D.
Reject Ho.
The football player's weights for each team are differnt because the p-value = 0.0472

8/30/2020
APUS CLE : MATH302 B011 Sum 20 : Tests & Quizzes