Multiple Regression: Case Problem Predicting Winnings for
NASCAR Drivers
Prior to beginning work on this discussion forum, watch the Week 5 Introduction(https://ashford.mediaspace.kaltura.com/media/BUS308+%7C+Week+5+Introduction/1_4c9qlzbm) video.NOTE: ANSWERS SHOULD BE DONE IN PARAGRAPHS AND THERE SHOULD BE AN EXCEL SHEET.Step
1: Read
●Review Case Problem 2: Predicting Winnings for NASCAR Drivers from Chapter 15 of the e book:Case Problem 2Predicting Winnings for NASCAR Drivers:***
***Step 2: Do
●Run a Regression for the Data File NASCAR(https://drive.google.com/file/d/1QXlGBXMClSMcVU0Pz3yn61bgBRja4U0z/view)
● (Chapter 15) using the video How to Add Excel’s Data Analysis ToolPak(https://ashford.mediaspace.kaltura.com/media/How+to+add+Excel%27s+Data+Analysis+ToolPak/0_qm214kiv) 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 (Top5), 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 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: (Please quote result from your data analysis when you answer the following questions.)
●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.
