Use CHISQTESThighlight actual counts highlight expected counts 00010 Part 4 of

# Use chisqtesthighlight actual counts highlight

• 26
• 95% (104) 99 out of 104 people found this document helpful

This preview shows page 20 - 25 out of 26 pages.

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.