Truck Maintenance Egpense'Miles Driven Age of Truck. _ A trucking company wants to study the effect of T1 _ 3903-55 _ 10,500 _ 10 miles driven and age of truck [independent T2 52.51.12 9,200 T variables} on maintenance expense {dependent T3 I $59155 I 9,200 3 variable; '1'}. Answer the following 5 questions. T4 $619.51 8,300 9 T5 ' $336.11 ' 5,500 5 a} Use the Data Analysis toolbox {Data :=- Data - - Analysis} to estimate the regression coefficients. T5 - $358.22 - 4'50\" 2- Please make sure I can see the Excel generated 17 _ $235.32 _ 3,500 2 output. T8. _ $174.33 _ 2.2;!) 3 T9 _ $255.30 _ 1,300 2 T10 $299.58 98:00 '4' b] Write the regression equation. lnte rpret the value T11 I 543504 I 55(1) 5 of all 3 regression coefcients. Estimate 1-12 I 330425 I 3500 1 maintenance expense if miles driven is SIS-GD and age T13 ' $22531 ' 25m 3 of trucl: is 10.5. T14 _ $179.53 _ 3100 3 c} what is the coefcient of determination [use the value of adjusted R2]? Interpret the value in the oontext of this problem. l-' C! T15 _ $725.55 _ 34m h : T1T _ $142.53 _ 13m _ T13 _ $915.53 _ lorm_ _ .11 T19 _ $313.45 _ 9300 T29 . $30333. . 390'? d] Use ANOVA table to test the Null Hypothesis that all bi = CI v5 Alternative Hypothesis that at least one bi at D. What is your conclusion? T22 $231.4s 2600 ml'l-I'H-JDO: e} Now test the hypothesis individually for the slopes of Miles Driven 84 Age of Truck? Based on your conclusion, if you have to remove one independent variable from the regression model, which one will you remove