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 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.
What is the
F-Stat
See Attached Excel for Data.
?
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
F-Stat
from the ANOVA output is

Question 18 of 20
1.0/ 1.0 Points
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.
Looking at the Summary output, which two teams have the biggest difference in weight?
See Attached Excel for Data.
Reference: The Sports Encyclopedia Pro Football
Football Weight data.xlsx
9 KB

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.