1. What is the expected mpg of a car with 8 cylinders, 307 displacements, 130 horsepower, 3504 weight, acceleration 12, model year 70 that is built in North America given the model in 1(a)? (5 points)
   1. Model A

SUMMARY OUTPUT Regression Statistics Multiple R 0.907854322 R Square 0.82419947 Adjusted R Square 0.81791643 Standard Error 3.306529531 Observations 392 ANOVA of SS MS F Significance F Regression 9 19631.60179 2181.289 224.4507 1.4345E-146 Residual 383 4187.391678 10.93314 Total 392 23818.99347 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept -19.38121618 4.699476772 -4.12412 4.57E-05 -28.62122022 -10.14121214 -28.62122022 -10.14121214 cylinders -0.489709424 0.321230857 -1.52448 0.128215 -1.121306208 0.14188736 -1.121306208 0.14188736 displacement 0.023978644 0.007653269 3.133124 0.001863 0.008930961 0.039026327 0.008930961 0.039026327 horsepower -0.018183464 0.013708599 -1.32643 0.185488 -0.045136998 0.00877007 -0.045136998 0.00877007 weight -0.006710384 0.000655133 -10.2428 6.38E-22 -0.007998492 -0.005422276 -0.007998492 -0.005422276 acceleration 0.079103036 0.098218498 0.805378 0.421101 -0.114011934 0.272218006 -0.114011934 0.272218006 model year 0.777026939 0.051784087 15.00513 2.33E-40 0.675210249 0.878843629 0.675210249 0.878843629 origin 1.426614114 0.276368151 5.162006 3.93E-07 0.883225359 1.970002869 0.883225359 1.970002869 Orgin= Europe 1.203388246 0.494220553 2.434921 0.015351 0.231663067 2.175113424 0.231663067 2.175113424 Orgin = Asia 0 65535 #NUM! 0 0 0SUMMARY OUTPUT Regression Statistics Multiple R 0.90769033 R Square 0.82390174 Adjusted R Square 0.81808745 Standard Error 3.30501642 Observations 392 ANOVA df MS F Significance F Regression 8 19624.51019 2453.06377 256.657253 9.6685E-149 Residual 384 4194.483283 10.9231335 Total 392 23818.99347 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept -17.760991 4.245163096 -4.1838182 3.5558E-05 -26.10766472 -9.4143168 -26.107665 -9.4143168 cylinders -0.502767 0.320674637 -1.5678415 0.11774176 -1.133264965 0.12773094 -1.133265 0.12773094 displacement 0.02337208 0.007612635 3.0701687 0.00229152 0.008404408 0.03833974 0.00840441 0.03833974 horsepower -0.0250027 0.010776253 -2.3201643 0.02085546 -0.046190525 -0.0038148 -0.0461905 -0.0038148 weight -0.0064598 0.000576282 -11.209467 2.0192E-25 -0.007592881 -0.0053268 -0.0075929 -0.0053268 model year 0.77388334 0.051613142 14.9939203 2.4772E-40 0.672403595 0.87536309 0.6724036 0.87536309 origin 1.42867798 0.276229806 5.17206308 3.7359E-07 0.885565719 1.97179024 0.88556572 1.97179024 Orgin= Europe 1.20583949 0.493985024 2.44104463 0.01509578 0.234585423 2.17709356 0.23458542 2.17709356 Orgin = Asia 0 65535 #NUM! 0 0 0