MULTIPLE REGRESSION ANALYSIS

Trip Size of Car

Observation 2
production household ownership (𝑌 − 𝑌𝑚𝑒𝑎𝑛 )2 (𝑋1 − 𝑋1,𝑚𝑒𝑎𝑛 ) (𝑋2 − 𝑋2 𝑚𝑒𝑎𝑛 )2
number
Y 𝑋1 𝑋2
1 4 1 0 25.30 4.50 1.40
2 7 1 1 4.12 4.50 0.03
3 2 1 0 49.43 4.50 1.40
4 3 1 0 36.36 4.50 1.40
5 4 1 1 25.30 4.50 0.03
6 5 1 1 16.24 4.50 0.03
7 6 2 0 9.18 1.26 1.40
8 9 2 2 0.00 1.26 0.67
9 8 2 2 1.06 1.26 0.67
10 7 2 1 4.12 1.26 0.03
11 7 2 1 4.12 1.26 0.03
12 6 2 1 9.18 1.26 0.03
13 8 3 1 1.06 0.01 0.03
14 5 3 0 16.24 0.01 1.40
15 9 3 2 0.00 0.01 0.67
16 10 3 2 0.94 0.01 0.67
17 9 3 1 0.00 0.01 0.03
18 8 3 1 1.06 0.01 0.03
19 9 3 2 0.00 0.01 0.67
20 10 3 1 0.94 0.01 0.03
21 13 4 2 15.76 0.77 0.67
22 12 4 1 8.82 0.77 0.03
23 9 4 2 0.00 0.77 0.67
24 14 4 2 24.70 0.77 0.67
25 8 4 1 1.06 0.77 0.03
26 9 4 1 0.00 0.77 0.03
27 10 4 1 0.94 0.77 0.03
28 15 5 1 35.64 3.53 0.03
29 14 5 1 24.70 3.53 0.03
30 16 5 2 48.58 3.53 0.67
31 11 6 1 3.88 8.29 0.03
32 16 6 2 48.58 8.29 0.67
33 15 6 2 35.64 8.29 0.67
Total 298 103 39
Mean 9.03 3.12 1.18
Analysis with only Size of household 𝑋1

SUMMARY OUTPUT

Regression Statistics
Multiple R 0.867402
R Square 0.752386
Adjusted R
Square 0.744132
Standard Error 1.877056
Observations 32

ANOVA
Significance
df SS MS F F
Regression 1 321.1748 321.1748 91.15637 1.33E-10
Residual 30 105.7002 3.523339
Total 31 426.875

Standard P- Lower Upper Lower Upper

Coefficients Error t Stat value 95% 95% 95.0% 95.0%
Intercept 2.4021 0.7843 3.0626 0.0046 0.8003 4.0039 0.8003 4.0039
1 2.1287 0.2230 9.5476 0.0000 1.6734 2.5841 1.6734 2.5841

X1 Line Fit Plot

20
15
10
Series1
4

5
Predicted 4
0
0 2 4 6 8
1
 PROBABILITY
RESIDUAL OUTPUT OUTPUT

Predicted Standard
Observation 4 Residuals Residuals Percentile 4
1 4.530864 2.469136 1.337174 1.5625 2
2 4.530864 -2.53086 -1.3706 4.6875 3
3 4.530864 -1.53086 -0.82905 7.8125 4
4 4.530864 -0.53086 -0.28749 10.9375 5
5 4.530864 0.469136 0.254063 14.0625 5
6 6.659612 -0.65961 -0.35722 17.1875 6
7 6.659612 2.340388 1.26745 20.3125 6
8 6.659612 1.340388 0.725895 23.4375 7
9 6.659612 0.340388 0.184339 26.5625 7
10 6.659612 0.340388 0.184339 29.6875 7
11 6.659612 -0.65961 -0.35722 32.8125 8
12 8.78836 -0.78836 -0.42694 35.9375 8
13 8.78836 -3.78836 -2.05161 39.0625 8
14 8.78836 0.21164 0.114615 42.1875 8
15 8.78836 1.21164 0.65617 45.3125 9
16 8.78836 0.21164 0.114615 48.4375 9
17 8.78836 -0.78836 -0.42694 51.5625 9
18 8.78836 0.21164 0.114615 54.6875 9
19 8.78836 1.21164 0.65617 57.8125 9
20 10.91711 2.082892 1.128002 60.9375 9
21 10.91711 1.082892 0.586446 64.0625 10
22 10.91711 -1.91711 -1.03822 67.1875 10
23 10.91711 3.082892 1.669557 70.3125 10
24 10.91711 -2.91711 -1.57978 73.4375 11
25 10.91711 -1.91711 -1.03822 76.5625 12
26 10.91711 -0.91711 -0.49666 79.6875 13
27 13.04586 1.954145 1.058278 82.8125 14
28 13.04586 0.954145 0.516722 85.9375 14
29 13.04586 2.954145 1.599833 89.0625 15
30 15.1746 -4.1746 -2.26078 92.1875 15
31 15.1746 0.825397 0.446998 95.3125 16
32 15.1746 -0.1746 -0.09456 98.4375 16
 𝑋1 Residual Plot
4
2
Residuals

0
-2 0 1 2 3 4 5 6 7

-4
-6
1

Analysis with both Size of household 𝑋1 and Car ownership 𝑋2

SUMMARY OUTPUT

Regression Statistics
Multiple R 0.917523
R Square 0.841848
Adjusted R
Square 0.830941
Standard Error 1.52577
Observations 32

ANOVA
Significance
df SS MS F F
Regression 2 359.3637 179.6819 77.18378 2.44E-12
Residual 29 67.51126 2.327975
Total 31 426.875

Standard P- Lower Upper Lower Upper

Coefficients Error t Stat value 95% 95% 95.0% 95.0%
Intercept 1.2052 0.7027 1.7150 0.0970 -0.2321 2.6424 -0.2321 2.6424
1 1.7982 0.1988 9.0465 0.0000 1.3916 2.2047 1.3916 2.2047
2 1.8467 0.4560 4.0502 0.0003 0.9142 2.7793 0.9142 2.7793
 PROBABILITY
RESIDUAL OUTPUT OUTPUT

Predicted Standard
Observation 4 Residuals Residuals Percentile 4
1 4.850055 2.149945 1.456868 1.5625 2
2 3.003308 -1.00331 -0.67987 4.6875 3
3 3.003308 -0.00331 -0.00224 7.8125 4
4 4.850055 -0.85006 -0.57602 10.9375 5
5 4.850055 0.149945 0.101607 14.0625 5
6 4.801465 1.198535 0.812164 17.1875 6
7 8.49496 0.50504 0.34223 20.3125 6
8 8.49496 -0.49496 -0.3354 23.4375 7
9 6.648212 0.351788 0.238382 26.5625 7
10 6.648212 0.351788 0.238382 29.6875 7
11 6.648212 -0.64821 -0.43925 32.8125 8
12 8.44637 -0.44637 -0.30247 35.9375 8
13 6.599622 -1.59962 -1.08395 39.0625 8
14 10.29312 -1.29312 -0.87626 42.1875 8
15 10.29312 -0.29312 -0.19862 45.3125 9
16 8.44637 0.55363 0.375157 48.4375 9
17 8.44637 -0.44637 -0.30247 51.5625 9
18 10.29312 -1.29312 -0.87626 54.6875 9
19 8.44637 1.55363 1.052787 57.8125 9
20 12.09127 0.908726 0.61578 60.9375 9
21 10.24453 1.755473 1.189562 64.0625 10
22 12.09127 -3.09127 -2.09474 67.1875 10
23 12.09127 1.908726 1.29341 70.3125 10
24 10.24453 -2.24453 -1.52096 73.4375 11
25 10.24453 -1.24453 -0.84333 76.5625 12
26 10.24453 -0.24453 -0.1657 79.6875 13
27 12.04268 2.957316 2.003967 82.8125 14
28 12.04268 1.957316 1.326336 85.9375 14
29 13.88943 2.110569 1.430185 89.0625 15
30 13.84084 -2.84084 -1.92504 92.1875 15
31 15.68759 0.312411 0.211699 95.3125 16
32 15.68759 -0.68759 -0.46593 98.4375 16
 X1 Line Fit Plot
20

15

10
4

Series1
5 Predicted 4
0
0 1 2 3 4 5 6 7
1

X2 Line Fit Plot

20

15

10
4

Series1
5 Predicted 4
0
0 0.5 1 1.5 2 2.5
0

X1 Residual Plot
4

2
Residuals

0
0 1 2 3 4 5 6 7
-2

-4
1
 X2 Residual Plot
4

2
Residuals

0
0 0.5 1 1.5 2 2.5
-2

-4
0

Correlation

Column 1 Column 2 Column 3

Column 1 1
Column 2 0.8752625 1
Column 3 0.6548908 0.45517035 1