Exam dataxlsx 9 KB A Exam 1 and the Final B Exam 2 and the Final C Exam 3 and

# Exam dataxlsx 9 kb a exam 1 and the final b exam 2

• 26
• 96% (115) 110 out of 115 people found this document helpful

This preview shows page 24 - 26 out of 26 pages.

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
B. 272.02C. 1713.76D. 21761.41Answer Key:B 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 5 columns including the top row with the Labels.Check the box Labels in the First Row and click OKIf done correctly the MSwithinfrom the ANOVA output isANOVASource of VariationSSdfMSFBetween Groups1713.764428.44 1.575049197Within Groups21761.4180272.02Total23475.1764784