MicrosoftВ® Office ExcelВ® 2007: Data Analysis and Business Modeling (Bpg -- Other)

  1. The file Nfl01.xlsx contains scores for every regular season game during the 2001 NFL season. Rate the teams. Who would you have forecast to make the Super Bowl?

  2. The file Nfl02.xlsx contains scores for every regular season game during the 2002 NFL season. Rate the teams. Who would you have forecast to make the Super Bowl?

  3. The file Nfl03.xlsx contains scores for every regular season game during the 2003 NFL season. Rate the teams. Who would you have forecast to make the Super Bowl?

  4. The file Nfl04.xlsx contains scores for every regular season game during the 2004 NFL season. Rate the teams. Who would you have forecast to make the Super Bowl?

  5. For the 2004 season, devise a method to predict the actual score of each game. Hint: Give each team an offensive rating and a defensive rating. Who had the best offense? Who had the best defense?

  6. True or False? An NFL team could lose every game and be an above average team.

  7. The file Nba01_02.xlsx contains scores for every game during the 2001–2002 NBA season. Rate the teams.

  8. The file Nba02_03.xlsx contains scores for every regular season game during the 2002– 2003 NBA season. Rate the teams.

  9. The file Worldball.xlsx contains all scores from the 2006 World Basketball Championships. Rate the teams. Who were the best three teams?

  10. Our method of rating teams works fine for football and basketball. What problems arise if we apply our method to hockey or baseball?.

Related

Категории