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
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
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