Q: The file P07_28.xlsx lists the scores of all
The file P07_28.xlsx lists the scores of all NFL games played during the 2014 season. Use this data set to rank the NFL teams from best to worst.
See AnswerQ: Carry out the suggestion in Modeling Issue 3. That is,
Carry out the suggestion in Modeling Issue 3. That is, find the ratings of the 2015 NFL teams using the sum of absolute prediction errors as the criterion to minimize. Discuss any differences in ratin...
See AnswerQ: In the pricing model with the constant elasticity demand function, the
In the pricing model with the constant elasticity demand function, the assumption is that all units demanded are sold. Suppose the company has the capacity to produce only 200 units. If demand is less...
See AnswerQ: Carry out the suggestion in Modeling Issue 2 for the 2015 NFL
Carry out the suggestion in Modeling Issue 2 for the 2015 NFL season. That is, use a weighted sum of squared prediction errors, where the weight on any game played k weeks ago is 0.95k. You can assume...
See AnswerQ: The file P07_31.xlsx contains scores on all of
The file P07_31.xlsx contains scores on all of the regular-season games in the NBA for the 2015–2016 basketball season. Use the same procedure as in Example 7.8 to rate the teams. Then sort the teams...
See AnswerQ: By the time you are reading this, the 2016 NFL season
By the time you are reading this, the 2016 NFL season will have finished, and the results should be available at www.pro-football-reference.com/years/ 2016/games.htm. Do whatever it takes to get the d...
See AnswerQ: By the time you are reading this, the 2016–2017
By the time you are reading this, the 2016–2017 NBA season will have finished, and the results should be available at www.basketball-reference.com/leagues/NBA_2017_games.html. Do whatever it takes to...
See AnswerQ: The method for rating teams is based on actual and predicted point
The method for rating teams is based on actual and predicted point spreads. This method can be biased if some teams run up the score in a few games. An alternative possibility is to base the ratings o...
See AnswerQ: For each of the following, answer whether it makes sense to
For each of the following, answer whether it makes sense to multiply the matrices of the given sizes. In each case where it makes sense, demonstrate an example in Excel, where you can make up the numb...
See AnswerQ: A project does not necessarily have a unique IRR. (Refer
A project does not necessarily have a unique IRR. (Refer to the previous problem for more information on IRR.) Show that a project with the following cash flows has two IRRs: year 1, -$20; year 2, $82...
See Answer
