Matt Kenseth won the 2012 Daytona 500, the most important race of the NASCAR season. His win was no surprise because for the 2011 season he finished fourth in the point standings with 2330 points, behind Tony Stewart (2403 points), Carl Edwards (2403 points), and Kevin Harvick (2345 points). In 2011 he earned $6,183,580 by winning three Poles (fastest driver in qualifying), winning three races, finishing in the top five 12 times, and finishing in the top ten 20 times. NASCAR’s point system in 2011 allocated 43 points to the driver who finished first, 42 points to the driver who finished second, and so on down to 1 point for the driver who finished in the 43rd position. In addition any driver who led a lap received 1 bonus point, the driver who led the most laps received an additional bonus point, and the race winner was awarded 3 bonus points. But the maximum number of points a driver could earn in any race was 48. Table 15.8 shows data for the 2011 season for the top 35 drivers (NASCAR website).
Step 2: Do
- Run a Regression for the Data File NASCAR (Chapter 15) using the video How to Add Excel’s Data Analysis ToolPak (Links to an external site.) for assistance.
In a managerial report,
- Suppose you wanted to predict Winnings ($) using only the number of poles won (Poles), the number of wins (Wins), the number of top five finishes (Top 5), or the number of top ten finishes (Top 10). Which of these four variables provides the best single predictor of winnings?
- Develop an estimated regression equation (look at Equation 15.6 in our textbook as an example) that can be used to predict Winnings ($) given the number of poles won (Poles), the number of wins (Wins), the number of top five finishes (Top 5), and the number of top ten (Top 10) finishes. Test for individual significance, and then discuss your findings and conclusions.
Step 3: Discuss:
- What did you find in your analysis of the data? Were there any surprising results? What recommendations would you make based on your findings? Include details from your managerial report to support your recommendations.
Guided Response: Review several of your peer’s posts. In a minimum of 100 words each, respond to at least two of your fellow students’ posts in a substantive manner, and provide information that they may have missed or may not have considered regarding the application of Multiple Regression in business and economics. Do you agree with their conclusions? Why or why not?
