Problems


  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?.




Microsoft Press - Microsoft Office Excel 2007. Data Analysis and Business Modeling
MicrosoftВ® Office ExcelВ® 2007: Data Analysis and Business Modeling (Bpg -- Other)
ISBN: 0735623961
EAN: 2147483647
Year: 2007
Pages: 200

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net