Question
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started