# Use chisqtesthighlight actual counts highlight

• 26
• 95% (132) 126 out of 132 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 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.