excel assignment

bahlman2

 

Using the McGraw-Hill Dataset in the Excel file, located here, complete the following tasks:

Task#1:

1) At the .10 significance level, is there a difference in the variation in team salary among the American and National League teams?

2) Create a variable that classifies a team's total attendance into three groups: less than 2.0 (million), 2.0 up to 3.0, and 3.0 and more. At the .05 significance level, is there a difference in the mean number of games won among the three groups?

  • 5 years ago
  • 15
Answer(2)

Purchase the answer to view it

NOT RATED
  • BUSU610_Excel_Assignment_6_Solutions.xlsx

Purchase the answer to view it

NOT RATED
  • Answerswithexceloutput.docx
  • BUSU610ExcelAssignment6.xlsx