Please answer Question 1 & 2 clearly including all stepts in an Excel format.

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. The following table shows data for the 2011 season for the top 35 drivers (NASCAR website). These data are contained in the file NASCAR. Please see the data file NASCAR Driver Points Poles Wins Top 5 Top 10 Winnings (5) 2403 1 5 9 19 6,529,870 Tony Stewart 2403 3 19 26 Carl Edwards 8,485,990 0 9 19 6,197,140 2345 Kevin Harvick 12 20 6.183.580 2220 Managerial Report 1. 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? (20%) 2. 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 finishes (Top 10). Test for individual significance and discuss your findings and conclusions. (20%) H OS 3 5 A 1 Driver 2 Tony Stewart 3 Carl Edwards 4 Kevin Harvick 5 Matt Kenseth 6 Brad Keselowski 7 Jimmie Johnson 8 Dale Earnhardt Jr. 9 Jeff Gordon 10 Denny Hamlin 11 Ryan Newman 12 Kurt Busch 13 Kyle Busch 14 Clint Bowyer 15 Kasey Kahne 16 A.J. Allmendinger 17 Greg Biffle 18 Paul Menard 19 Martin Truex Jr. 20 Marcos Ambrose 21 Jeff Burton B Points Poles 2403 2403 2345 2330 2319 2304 2290 2287 2284 2284 2262 2246 1047 1041 1013 997 947 937 936 935 D Wins 1 3 0 3 1 0 1 1 0 3 3 1 0 2 0 3 0 1 0 0 E Top 5 5 1 4 3 3 2 0 3 1 1 2 4 1 1 0 0 1 0 1 0 F G Top 10 Winnings (S) 9 19 6,529,870 19 26 8,485,990 9 19 6,197,140 12 20 6,183,580 10 14 5,087,740 14 21 6,296,360 4 12 4,163,690 13 18 5,912,830 5 14 5,401,190 9 17 5,303,020 8 16 5,936,470 14 18 6,161,020 4 16 5,633,950 8 15 4,775,160 1 10 4.825,560 10 4,318,050 4. 8 3,853,690 3 12 3,955,560 5 12 4,750,390 2 5 3,807,780 50.700 00 ::: co NU) O C D E F 5 2 2 2 20 Marcos Ambrose 21 Jeff Burton 22 Juan Montoya 23 Mark Martin --2 24 David Ragan 25 Joey Logano 26 Brian Vickers 27 Regan Smith P. 28 Jamie McMurray Ar 29 David Reutimann io! 30 Bobby Labonte m 31 David Gilliland ng 32 Casey Mears 33 Dave Blaney 34 Andy Lally* 35 Robby Gordon 36 J.J. Yeley ssi B 936 935 932 930 906 902 846 820 795 757 670 572 541 508 398 268 192 0 0 2 2 2 2 0 0 1 1 0 0 0 0 0 0 0 1 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 2 4 4 3 2 2 1 1 1 0 1 0 0 0 12 5 8 10 8 6 7 5 4 3 2 2 0 1 0 0 0 G 4,750, 3,807, 5,020, 3,830.9 4,203, 3,856, 4,301, 4,579, 4,794, 4,374, 4,505, 3,878,9 2.838,9 3,229, 2,868 2,271,8 2,559, 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. The following table shows data for the 2011 season for the top 35 drivers (NASCAR website). These data are contained in the file NASCAR. Please see the data file NASCAR Driver Points Poles Wins Top 5 Top 10 Winnings (5) 2403 1 5 9 19 6,529,870 Tony Stewart 2403 3 19 26 Carl Edwards 8,485,990 0 9 19 6,197,140 2345 Kevin Harvick 12 20 6.183.580 2220 Managerial Report 1. 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? (20%) 2. 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 finishes (Top 10). Test for individual significance and discuss your findings and conclusions. (20%) H OS 3 5 A 1 Driver 2 Tony Stewart 3 Carl Edwards 4 Kevin Harvick 5 Matt Kenseth 6 Brad Keselowski 7 Jimmie Johnson 8 Dale Earnhardt Jr. 9 Jeff Gordon 10 Denny Hamlin 11 Ryan Newman 12 Kurt Busch 13 Kyle Busch 14 Clint Bowyer 15 Kasey Kahne 16 A.J. Allmendinger 17 Greg Biffle 18 Paul Menard 19 Martin Truex Jr. 20 Marcos Ambrose 21 Jeff Burton B Points Poles 2403 2403 2345 2330 2319 2304 2290 2287 2284 2284 2262 2246 1047 1041 1013 997 947 937 936 935 D Wins 1 3 0 3 1 0 1 1 0 3 3 1 0 2 0 3 0 1 0 0 E Top 5 5 1 4 3 3 2 0 3 1 1 2 4 1 1 0 0 1 0 1 0 F G Top 10 Winnings (S) 9 19 6,529,870 19 26 8,485,990 9 19 6,197,140 12 20 6,183,580 10 14 5,087,740 14 21 6,296,360 4 12 4,163,690 13 18 5,912,830 5 14 5,401,190 9 17 5,303,020 8 16 5,936,470 14 18 6,161,020 4 16 5,633,950 8 15 4,775,160 1 10 4.825,560 10 4,318,050 4. 8 3,853,690 3 12 3,955,560 5 12 4,750,390 2 5 3,807,780 50.700 00 ::: co NU) O C D E F 5 2 2 2 20 Marcos Ambrose 21 Jeff Burton 22 Juan Montoya 23 Mark Martin --2 24 David Ragan 25 Joey Logano 26 Brian Vickers 27 Regan Smith P. 28 Jamie McMurray Ar 29 David Reutimann io! 30 Bobby Labonte m 31 David Gilliland ng 32 Casey Mears 33 Dave Blaney 34 Andy Lally* 35 Robby Gordon 36 J.J. Yeley ssi B 936 935 932 930 906 902 846 820 795 757 670 572 541 508 398 268 192 0 0 2 2 2 2 0 0 1 1 0 0 0 0 0 0 0 1 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 2 4 4 3 2 2 1 1 1 0 1 0 0 0 12 5 8 10 8 6 7 5 4 3 2 2 0 1 0 0 0 G 4,750, 3,807, 5,020, 3,830.9 4,203, 3,856, 4,301, 4,579, 4,794, 4,374, 4,505, 3,878,9 2.838,9 3,229, 2,868 2,271,8 2,559