As part of an international study on energy consumption, data were collected on the number of cars in the country and the total travel in kilometers. The data for 11 countries are shown below:
|
Country |
Total Cars (millions) |
Travel (billion km) |
|
Finland |
1.82 |
34.66 |
|
Denmark |
1.66 |
30.76 |
|
Britain |
21.32 |
352.76 |
|
Australia |
8.53 |
138.22 |
|
Sweden |
3.32 |
53.21 |
|
Netherlands |
5.53 |
83.69 |
|
France |
23.27 |
348.2 |
|
Norway |
1.59 |
23.54 |
|
Italy |
26.12 |
367.85 |
|
Germany |
43.75 |
608.52 |
|
Japan |
40.25 |
439.3 |
The Excel output from a least squares linear regression of the travel on the number of cars is shown below.
|
SUMMARY OUTPUT |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Regression Statistics |
|
|
|
|
|
|
|
Multiple R |
0.981387 |
|
|
|
|
|
|
R Square |
0.963121 |
|
|
|
|
|
|
Adjusted R Square |
0.959023 |
|
|
|
|
|
|
Standard Error |
41.31075 |
|
|
|
|
|
|
Observations |
11 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Coefficients |
Standard Error |
t Stat |
P-value |
Lower 95% |
Upper 95% |
|
Intercept |
20.78336 |
18.26151 |
1.138 |
0.284 |
-20.527 |
62.093 |
|
Total Cars (millions) |
12.7122 |
0.829183 |
15.33 |
0.000 |
10.836 |
14.587 |