This is the updated data, any help with any question (preferably 5-7) would be greatly appreciated! Thank you!
All-NASCAR-Data (3) All NASCAR Data.pdf (page 2 of 15) 4 v Q Search All-NASCAR-Data (3) All NAS.. 2008 Joe Nemech 1989 32 O 2681760 2010 Joe Nemech 1361 31 2535500 2009 Juan Monto 6252 36 18 5274190 2006 Juan Montc 61 1 61425 2010 Juan Montc 4118 36 14 5088410 OONOOWONOH 2008 Juan Montc 3329 36 4409360 2009 Kasey Kahn 6128 36 14 5760140 2007 Kasey Kahn 3489 36 5148470 2 2007 Kevin Harvi 6199 36 15 7494590 2008 Kevin Harvi 6408 36 19 5603650 2006 Kevin Harvi 6397 36 20 6201580 2010 Kevin Harvi 6581 36 JOOP 26 6812580 2008 Kurt Busch 3635 36 10 4469510 2010 Kurt Busch 6142 36 17 6732740 DOONOOOOH OOO AHNHWUOHONOHOOOO 2007 Kyle Busch 6293 36 20 4685520 HON 2009 Kyle Busch 4457 36 13 6204750 2007 Mark Marti 2960 24 11 4097200 2010 Mark Marti 4364 36 11 4481760 2006 Mark Marti 6168 36 15 4282550 2007 Martin True 6164 36 14 5003880 2008 Martin True 3839 36 11 4663450 2006 Martin True 3673 36 4193120 2008 Matt Kense 6184 36 20 5526940 2010 Matt Kense 6294 36 O 15 5621480 2009 Matt Kense 4389 36 12 7085710 2007 Michael Wa 1149 14 N 1461080 2006 Michael Wa 2350 33 O 2971980 DO 2008 Michael W: 2889 36 3663190All-NASCAR-Data (3) All NASCAR Data.pdf (page 6 of 15) 4 3 Q Search 7 All-NASCAR-Data (3) All NAS.. MAKE AVG_ST AVG_FIN AVG_POS LAPS LED RATING AVERAGE_S make_ford Ford 29.8 26.1 29.4 3315 50.8 1.4 Dodge 34.1 29 34.6 2238 40.3 4.9 Ford 30.3 28.4 30.5 5364 44 0.7 Ford 30 29 31.8 6517 1 43.8 0.05 Dodge 20.2 22.2 22.4 10109 17 66.2 0.5 Dodge 21.6 22 21.7 9954 63 67.9 Ford 9 29 16.1 187 0 83.6 -2 Dodge 20.3 33.3 31 333 2 50.3 3.333 Chevrolet 16.8 19.3 19.2 10040 126 76.6 0.222 Toyota 23 25.1 24.2 5856 106 64.4 0.8 Ford 16.8 13.9 14.7 9976 515 92.9 0.6 Toyota 27.1 29.5 29.7 5507 49.6 -0.2 Chevrolet 19 18.9 20.7 10157 39 72.6 H H P P OP OO OOOOOOPOOOHOOHPOP Chevrolet 26.1 19.8 22.8 10323 24 65.6 0.2 5 Chevrolet 14.9 14.4 14.4 10133 400 91.7 -0.7 Chevrolet 17.4 13.8 15.2 10437 387 87.4 1.6 Chevrolet 20.3 19.7 18.8 10304 112 74.9 Chevrolet 10.3 14.1 11.6 10574 896 99 -2.861 Toyota 31.6 41.1 40.6 1130 3 30.8 0.4 Ford 32 38.2 38.2 3707 A 34.2 0.1 Dodge 28.3 24.4 25.5 10480 9 57.4 0.722 Ford 22.1 28.3 28 4271 53.4 1.4 Ford 27.7 27.4 27.5 9485 18 54.5 1.6 Ford 36 29.3 31.1 9696 8 43.2 0.5 Ford 26.9 24.4 22.9 9919 63 0.1 Of Ford 39 33.5 35.6 546 40.9 0.5 6 Ford 364 296 32 3176 43.3 23\fYEAR DRIVER POINTS STARTS POLES WINS TOP_5 TOP_10 WINNING 2010 Bill Elliott 1107 13 0 1314990 2006 Bill Elliott 765 10 1056130 2007 Bill Elliott 1579 20 2056930 ooooo 2008 Bill Elliott 1528 20 1965750 booooooo oooooo 2007 Bobby Labc 3517 36 4586960 2006 Bobby Labc 3567 36 4651090 2009 Boris Said 152 160338 2008 Boris Said 194 3 260953 2006 Brian Vicke 3906 36 3917680 OH 2007 Brian Vicke 2065 23 2105820 2007 Carl Edward 6222 36 4611970 2010 Casey Mear 1573 21 1871550 2007 Casey Mea 3949 36 4179200 2009 Casey Mear 3759 36 3958460 2010 Clint Bowye 6155 36 PHONOOHOH 4700630 2007 Clint Bowye 6377 36 DOOOOOPOPNOHOWOP 4215870 OO OOOH OHOOOAUINOUOHHNOOWE 2006 Clint Bowye 3833 36 3924410 2008 Dale Earnha 6127 36 4611290 2009 Dave Blane 1204 30 2343060 2010 Dave Blane 1416 29 2326360 2006 Dave Blane 3259 36 3479640 x O 1 0 0 F J G N U Q O W O O O O N O N O N OO C H V O P O O U U DOOD WOOOO 2006 David Gillile 1178 15 1521450 2007 David Gillila 2924 36 4330840 2010 David Gillila 2445 32 3035140 2009 David Ragal 3252 36 3682210 2006 David Ragal 88 2 129610 2010 David Stren 825 11 o 946775 2008 David Stren 34 1 91525 2009 David Stren 2919 33 4141680 2007 David Stren 3163 36 3184560 2006 David Stren 2865 34 3456110 2008 Denny Ham 6214 36 5494360 2009 Elliott Sadle 3350 36 3819100 2007 Elliott Sadle 3140 36 3972990 HNNOON 2006 Greg Biffle 4075 36 4602720 2008 Greg Biffle 5467 36 4906160 JW WODHON NUN OOH NOOOOO 2007 Greg Biffle 3991 36 4397950 2008 Jeff Burton 6335 36 5542180 VOUOHNOOHNANNOOHOO 2006 Jeff Burton 6228 36 5008880 2010 Jeff Burton 6033 36 5178400 2007 Jeff Gordon 5646 36 7148620 NVC 2006 Jeff Gordon 5256 36 5975870 2009 Jeff Gordon 6473 36 25 6476460 2008 Jeff Gordon 5316 36 5944140 2006 Jimmie Johi 6475 36 24 8909140 2010 Jimmie Joh 6622 36 23 7264780 2009 Jimmie Johi 6652 36 16 24 73396301. Use your study in Statistical Inferences, and the sample NASCAR data you are given, please estimate the amount of money an average driver makes winning NASCAR tournaments. From previous studies, you know that the standard deviation of NASCAR winnings is $2.222 million. For your work: a) Identify what strategy/formula you use b) Calculate the average money won by an average NASCAR driver. Be 95%% confident in your calculation. c) Explain/interpret your answer 2. Use your study in Statistical Inferences, and the sample NASCAR data you are given, please estimate the percent of times Ford cars are driven in NASCAR tournaments. You want to answer with 90% confidence. a) Identify what strategy/formula you use b) Calculate the average money won by an average NASCAR driver. Be 95%% confident in your calculation. c) Explain/interpret your answer 3. Use your study in Determining Relationships, to answer the following scenario. The NASCAR CEO believes that drivers who drive Ford cars, as compared to any other car, win more money. He tasks you to verify this using the sample NASCAR data you have. Hint: categorize your sample data into Ford driven cars and non-Ford. Also, for every driver categorize the driver based on whether he/she won less than the average winnings or more than the average winnings (average included). For your work: a) Identify what strategy/formula you use. b) Test if Ford drivers make more than average winnings. Use 95% confidence. c) Explain/interpret your answer d) Show a plot of your results. Make sure it has a title, legend, axes named. 1. Use your study in Determining Relationships, to test whether there is a relationship among any pair of numeric variables in the NASCAR data. Interpret the answers you find for every relationship. For the strongest relationship and the weakest relationship plot the data and discuss it. Explain if the plot shows the relationship index you calculated 5. Use the regression analysis output in the worksheet NASCAR Regression. a)Interpret the regression results. Make sure you discuss the R2, coefficients, identify the significant variables. b) Using your analysis, list the top 3 factors you will use in your advertisement to attract more NASCAR drivers. c) Now add the Ford car to the regression model. Does the model improve? By how much? Can the CEO advertise that drivers should drive Ford cars because they will make more money? 6. Use your study in Finding Differences to test whether the average driver drove the same number of laps when driving Ford cars, as compared to when driving Dodge cars. Be 90% confident in your answer. 7. Use your study in Finding Differences to test whether Toyota cars are driven as frequently as Chevy cars. Interpret your answer. Be 95%% confident in your analysis.SUMMARY OUTPUT Regression Statistics Multiple R 0.957432522 R Square 0.916677034 Adjusted R Square 0.912510886 Standard Error 600910.0729 Observations 190 ANOVA of 55 MS F Significance F Regression 9 7.15E+14, 7.95E+13 220.0299 3.54614E-92 Residual 180 6.5E+13] 3.618+11 Total 189 7.8E+141 Coefficients andard Erro t Stat P-value Lower 95% Upper 95% lower 95.0%Upper 95.0% Intercept 30404.49328 781984 -0.03888 0.969028 -1573439.392 1512630 -1573439 1512630 POINTS -78.08473409 92.46174! -0.84451 0.399506 -260.5330818 104.3636 -260.533 104.3636 STARTS 76478.72308 15134.761 5.053183 1.06E-06 46614.3424 106343.1 46614.34 106343.1 POLES -40064.1891 38994.44 -1.02743 0.305595 -117009.2127 36880.83 -117009 36880.83 WINS 205975.8788 44413.13 4.637725 6.75E-06 118338.5314 293613.2 118338.5 293613.2 TOP_10 78947.18153 21195.24! 3.72476 0.000261 37124.08651 120770.3 37124.09 120770.3 AVG_ST -8910.66609 13489.651 -0.66056 0.509742 -35528.85448 17707.52 -35528.9 17707.52 LAPS 111.1087178 54.03331 2.0563 0.041197 4.488528342 217.7289 4.488528 217.7289 LED 42.78290972 236.4279, 0.180955 0.856606 -423.7439824 509.3098 -423.744 509.3098 RATING 6095.616137 8791.049 0.693389 0.488959 -11251.15296 23442.39 -11251.2 23442.39
