Use =CHISQ.TEST(highlight actual counts, highlight expected counts) = 0.0010
Part 4 of 4 - F-Distribution and Three or More Means
4.0/ 4.0 Points
Question 17 of 201.0/ 1.0 PointsThe 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.
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 OKIn the Input Range: Highlight all 4 columns including the top row with the Labels.Check the box Labels in the First Row and click OKIf done correctly the F-Stat from the ANOVA output isANOVASource of VariationSSdfMSFBetween Groups1878.9456333 626.31521114.521Within Groups13298.8491696 138.5296787 Total15177.7947999 Question 18 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 games.Looking at the Summary output, which two teams have the biggest difference in weight?See Attached Excel for Data.Reference: The Sports Encyclopedia Pro FootballFootball Weight data.xlsx9 KB
A. San Francisco 49ers and Green Bay PackersB.

San Francisco 49ers and Miami Dolphins
C.
Denver Broncos and San Francisco 49ers
D.
Denver Broncos and Miami Dolphins
Answer Key:C
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 19 of 20
1.0/ 1.0 Points
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.
Looking at the Summary output, which two Exams have the biggest difference in average?
See Attached Excel for Data.