Posted: May 4th, 2022
Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates
For This or a Similar Paper Click To Order Now
Step 1: Read
·
Review Case Problem
2: Predicting Winnings for NASCAR Drivers. (Attached)
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 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.
Place an order in 3 easy steps. Takes less than 5 mins.