Regression Statistics

Multiple R 0.86

R Square

Adjusted R Square 0.74

Standard Error

Observations 127

ANOVA

df SS MS F Significance F

Regression 1 18147499.53 18147499.53 362.3955605 9.5515E-39

Residual 6259561.892 50076.49514

Total 24407061.42

Coefficients Standard Error t Stat P-value Lower 95% Upper 95%

Intercept 882.81 48.76 18.11 9.6233E-37 786.31 979.31

Eng. Size / DISP 16.69 9.5515E-39 284.66 350.71

(1) (To at two decimal places) a point estimate of the population slope is ______ and a point estimate of the population intercept is ______.

(2) (To two decimal places) the coefficient of determination equals ______.

(3) (To two decimal places) the standard error of the estimate of Fuel L/Yr equals _______.

(4) (To two decimal places) based on the sample data, the computed value of the F test statistic, for the test of whether there is any linear relationship equals ______.

(5) For the F-test of "no linear regression", the numerator and denominator degrees of freedom associated with the test statistic are _______ and ______ respectively.

(6) (To two decimal places) the missing value for the t-statistic in cell D18 is ______.

(7) There are three p-values are highlighted in green.

For the test of the null hypothesis that the population regression coefficient (the slope) equals zero, i.e. for the test of "no linear regression", the decision regarding Ho (reject or do not reject) is based on the p-value in cell

F12

E17

B4

Make/Model Class Eng. Size / DISP Tran gear Type FUEL L/yr L/100km City L/100km Hwy CO2 kg per year

ACURA TSX C 3.5 S5E Z 1800 10.7 7 4140

AUDI A4 C 2 V+ Z 1560 8.9 6.5 3588

AUDI A4 QUATTRO C 2 M6+ Z 1620 9.5 6.5 3726

AUDI A4 QUATTRO C 2 S8+ Z 1740 10 7 4002

AUDI S4 C 3 M6+ Z 2060 12.2 8.1 4738

AUDI S4 C 3 S7+ Z 2040 12.1 7.9 4692

BMW 323i C 2.5 E6+ Z 1840 11.2 6.7 4232

BMW 323i C 2.5 M6+ Z 1840 11.1 6.9 4232

BMW 328i C 3 E6+ Z 1820 10.9 6.8 4186

BMW 328i C 3 M6+ Z 1800 10.7 6.9 4140

BMW 328i xDRIVE C 3 M6+ Z 2040 12.3 7.6 4692

BMW 328i xDRIVE C 3 E6+ Z 2000 11.8 7.8 4600

BMW 335d C 3 E6+ D 1480 9 5.4 3996

BMW 335i C 3 E6+ Z 1900 11.3 7.2 4370

BMW 335i C 3 M6+ Z 1860 11 7.1 4278

BMW 335i xDRIVE C 3 M6+ Z 1880 11 7.5 4324

BMW 335i xDRIVE C 3 E6+ Z 1880 11.1 7.4 4324

BMW M3 SEDAN C 4 X7+ Z 2580 15.4 9.9 5934

BMW M3 SEDAN C 4 M6+ Z 2560 15.3 9.7 5888

CHEVROLET AVEO C 1.6 M5+ X 1340 7.6 5.7 3082

CHEVROLET AVEO C 1.6 E4E X 1420 8.2 5.8 3266

CHEVROLET CAMARO C 3.6 S6E X 1880 11.4 6.9 4324

CHEVROLET CAMARO C 3.6 M6+ X 2000 12.4 7.1 4600

CHEVROLET CAMARO C 3.6 E6E X 1820 11.2 6.6 4186

CHEVROLET CAMARO SS C 6.2 S6E Z 2180 13.3 8 5014

CHEVROLET CAMARO SS C 6.2 M6+ Z 2200 13.2 8.2 5060

CHEVROLET CRUZE C 1.4 S6E X 1440 8.5 5.5 3312

CHEVROLET CRUZE C 1.8 S6E X 1520 9.2 5.6 3496

CHEVROLET CRUZE C 1.8 M6+ X 1360 7.8 5.4 3128

CHRYSLER 200 CONVERTIBLE C 2.4 E4+ X 1760 10.3 6.9 4048

CHRYSLER 200 CONVERTIBLE C 2.4 S6+ X 1860 11.5 6.8 4278

CHRYSLER 200 CONVERTIBLE FFV C 3.6 S6+ X 1820 11 6.8 4186

CHRYSLER 200 CONVERTIBLE FFV C 3.6 S6+ E 2540 15.3 9.5 4064

FORD FOCUS C 2 E4E X 1420 8.2 5.8 3266

FORD FOCUS C 2 M5+ X 1380 8 5.6 3174

HONDA ACCORD 2DR COUPE C 2.4 E5E X 1540 9.2 6 3542

HONDA ACCORD 2DR COUPE C 2.4 M5+ X 1560 9 6.2 3588

HONDA ACCORD 2DR COUPE C 3.5 M6+ X 2000 11.9 7.6 4600

HONDA ACCORD 2DR COUPE C 3.5 S5E X 1780 10.7 6.7 4094

HONDA CIVIC HYBRID C 1.3 V X 900 4.7 4.3 2070

HONDA INSIGHT DX C 1.3 V X 940 4.8 4.6 2162

HONDA INSIGHT EX C 1.3 V X 940 4.8 4.6 2162

HONDA INSIGHT LX C 1.3 V X 940 4.8 4.6 2162

HYUNDAI ACCENT C 1.6 A4E X 1340 7.6 5.5 3082

HYUNDAI ACCENT C 1.6 M5+ X 1320 7.3 5.7 3036

KIA FORTE C 2 S6E X 1380 8 5.6 3174

KIA FORTE C 2 M6+ X 1420 8.2 5.7 3266

KIA FORTE C 2.4 S6E X 1540 8.9 6.2 3542

KIA FORTE C 2.4 M6+ X 1560 9.2 6.2 3588

KIA FORTE KOUP C 2 S6E X 1380 8 5.6 3174

KIA FORTE KOUP C 2 M6+ X 1420 8.2 5.7 3266

KIA FORTE KOUP C 2.4 S6E X 1540 8.9 6.2 3542

KIA FORTE KOUP C 2.4 M6+ X 1560 9.2 6.2 3588

KIA RIO C 1.6 A4E X 1340 7.6 5.5 3082

KIA RIO C 1.6 M5+ X 1300 7.1 5.8 2990

LEXUS CT 200h C 1.8 V X 920 4.5 4.8 2116

LEXUS HS 250h C 2.4 V X 1140 5.6 5.9 2622

MAZDA MAZDA2 C 1.5 E4+ X 1360 7.5 6 3128

MAZDA MAZDA2 C 1.5 M5+ X 1260 6.8 5.6 2898

MAZDA MAZDA3 C 2 M5+ X 1420 8.1 5.9 3266

MAZDA MAZDA3 C 2 S5+ X 1500 8.7 6 3450

MAZDA MAZDA3 C 2.5 M6+ X 1740 10.2 6.9 4002

MAZDA MAZDA3 C 2.5 S5+ X 1620 9.2 6.7 3726

MERCEDES-BENZ C 250 C 2.5 E7 Z 1940 11.5 7.5 4462

MERCEDES-BENZ C 250 C 2.5 M6 Z 1940 11.7 7.3 4462

MERCEDES-BENZ C 250 4MATIC C 2.5 E7 Z 2020 11.9 7.9 4646

MERCEDES-BENZ C 300 C 3 E7 Z 1980 11.7 7.8 4554

MERCEDES-BENZ C 300 C 3 M6 Z 1980 11.7 7.7 4554

MERCEDES-BENZ C 300 4MATIC C 3 E7 Z 2020 11.8 7.9 4646

MERCEDES-BENZ C 350 C 3.5 E7 Z 2060 12.3 8 4738

MERCEDES-BENZ C 350 4MATIC C 3.5 E7 Z 2100 12.4 8.2 4830

MERCEDES-BENZ C 63 AMG C 6.2 S7 Z 2780 16.9 10.3 6394

MERCEDES-BENZ CL 550 4MATIC C 4.7 E7 Z 2280 13.7 8.7 5244

MERCEDES-BENZ CL 600 C 5.5 E5 Z 2940 17.8 10.9 6762

MERCEDES-BENZ CL 63 AMG C 5.5 S7 Z 2420 14.3 9.5 5566

MERCEDES-BENZ CL 65 AMG C 6 S5 Z 2920 17.5 10.9 6716

MERCEDES-BENZ CLS 550 C 5.5 E7 Z 2580 15.5 9.8 5934

MERCEDES-BENZ CLS 63 AMG C 6.2 S7 Z 2960 17.8 11.2 6808

MINI COOPER COUNTRYMAN C 1.6 E6+ Z 1480 8.1 6.6 3404

MINI COOPER COUNTRYMAN C 1.6 M6+ Z 1300 7.3 5.6 2990

MINI COOPER S COUNTRYMAN C 1.6 E6+ Z 1440 8.1 6.1 3312

MINI COOPER S COUNTRYMAN C 1.6 M6+ Z 1420 7.8 6.1 3266

MINI COOPER S COUNTRYMAN ALL4 C 1.6 E6+ Z 1540 8.7 6.5 3542

MINI COOPER S COUNTRYMAN ALL4 C 1.6 M6+ Z 1460 8.1 6.3 3358

MITSUBISHI LANCER C 2 M5+ X 1460 8.4 5.9 3358

MITSUBISHI LANCER C 2 V+ X 1400 8 5.9 3220

MITSUBISHI LANCER C 2 S6+ Z 2020 11.9 7.9 4646

MITSUBISHI LANCER EVOLUTION C 2 M5+ Z 2140 12.4 8.7 4922

MITSUBISHI LANCER EVOLUTION C 2 S6+ Z 2200 12.7 9 5060

ROLLS-ROYCE PHANTOM COUPE C 6.7 E6+ Z 3080 18.7 11.4 7084

ROLLS-ROYCE PHANTOM DROPHEAD COUPE C 6.7 E6+ Z 3080 18.7 11.4 7084

SCION tC C 2.5 M6+ X 1600 9.2 6.4 3680

SCION tC C 2.5 S6E X 1540 8.9 6.3 3542

SUBARU IMPREZA AWD C 2.5 M5+ X 1840 10.8 7.4 4232

SUBARU IMPREZA AWD C 2.5 S4E X 1820 10.4 7.5 4186

SUBARU IMPREZA AWD C 2.5 M5+ Z 1960 11.1 8 4508

SUBARU IMPREZA AWD C 2.5 M6+ Z 2160 12.4 8.8 4968

SUZUKI KIZASHI AWD C 2.4 V X 1640 9.3 6.8 3772

SUZUKI KIZASHI S C 2.4 V X 1520 8.7 6.3 3496

SUZUKI KIZASHI SPORT C 2.4 M6+ X 1720 10.1 6.7 3956

SUZUKI SX4 SEDAN JA C 2 M6+ X 1520 9 6 3496

SUZUKI SX4 SEDAN JA C 2 V X 1440 8 6.1 3312

SUZUKI SX4 SEDAN SPORT C 2 M6+ X 1560 9.1 6.2 3588

SUZUKI SX4 SEDAN SPORT C 2 V X 1580 8.9 6.7 3634

TOYOTA COROLLA C 2.4 S5E X 1620 9.4 6.5 3726

TOYOTA COROLLA C 2.4 M5+ X 1640 9.5 6.7 3772

TOYOTA COROLLA C 1.8 E4E X 1360 7.8 5.7 3128

TOYOTA COROLLA C 1.8 M5+ X 1320 7.4 5.6 3036

VOLKSWAGEN GOLF C 2.5 M5+ X 1640 9.9 6.2 3772

VOLKSWAGEN GOLF C 2.5 S6+ X 1600 9.1 6.5 3680

VOLKSWAGEN GOLF TDI CLEAN DIESEL C 2 M6+ D 1160 6.7 4.6 3132

VOLKSWAGEN GOLF TDI CLEAN DIESEL C 2 S6+ D 1160 6.7 4.7 3132

VOLKSWAGEN GTI C 2 M6+ Z 1700 10 6.7 3910

VOLKSWAGEN GTI C 2 S6+ Z 1520 8.7 6.3 3496

VOLKSWAGEN JETTA C 2 M5+ X 1540 9.1 6 3542

VOLKSWAGEN JETTA C 2 S6+ X 1620 9.3 6.7 3726

VOLKSWAGEN JETTA C 2.5 M5+ X 1640 9.9 6.2 3772

VOLKSWAGEN JETTA C 2.5 S6+ X 1580 9.1 6.5 3634

VOLKSWAGEN JETTA TDI CLEAN DIESEL C 2 M6+ D 1160 6.7 4.6 3132

VOLKSWAGEN JETTA TDI CLEAN DIESEL C 2 S6+ D 1160 6.7 4.7 3132

VOLKSWAGEN PASSAT CC C 2 M6+ Z 1700 10 6.7 3910

VOLKSWAGEN PASSAT CC C 2 S6+ Z 1660 9.6 6.6 3818

VOLKSWAGEN PASSAT CC 4MOTION C 3.6 S6+ Z 2140 12.7 8.3 4922

VOLVO C30 T5 C 2.5 M6 X 1740 10.2 6.8 4002

VOLVO C30 T5 C 2.5 S5E X 1720 10.1 6.6 3956

VOLVO S40 T5 C 2.5 S5E X 1720 10.1 6.6 3956

VOLVO S60 T6 AWD C 3 S6E X 1940 11.3 7.7 4462