0% found this document useful (0 votes)
0 views22 pages

Multiple Regression

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1/ 22

Vertical Import

Year Dominant specialization integration dependence


(X1) (X2) (X3)
1974-75 70.580 22.030 18.290
1975-76 75.390 21.930 18.560
1976-77 74.430 23.600 16.770
1977-78 73.510 21.270 15.160
1978-79 74.780 20.040 15.430
1979-80 71.730 19.340 16.920
1980-81 72.340 18.270 17.920
1981-82 73.140 18.910 16.060
1982-83 76.310 17.330 15.930
1983-84 75.400 17.720 15.520
1984-85 75.370 18.760 14.230
1985-86 73.030 18.320 16.030
1986-87 74.660 17.560 17.350
1987-88 77.510 16.790 16.440
1988-89 77.320 17.760 16.040
1989-90 77.300 18.140 15.340

SUMMARY OUTPUT

Regression Statistics
Multiple R 0.9323812191
R Square 0.8693347378
Adjusted R Square 0.782224563
Standard Error 0.5545885993
Observations 16
ANOVA
df SS
Regression 6 18.4166771202
Residual 9 2.76811662983
Total 15 21.18479375

Coefficients Standard Error


Intercept -3.047200264 9.70270676442
Dominant specialization 0.0930465074 0.1005277516
Vertical integration 0.2502424878 0.16447200273
Import dependence -0.101456532 0.17109577988
R&D intensity 1.1340792178 0.39816909582
Export competitiveness 0.3784979331 0.15056782165
Capital intensity -2.07152722 0.98775866726

0.92558030902
1.52148988035
Export
R&D competitiveness Capital Post-tax profit
intensity intensity margin
(X4) (X5) (X6) (Y)
1.480 3.610 4.300 1.270
1.700 4.380 4.710 1.390
1.810 5.880 4.630 3.200
1.770 7.800 4.480 3.120
1.960 6.920 4.100 3.190
2.620 6.110 4.000 3.280
3.390 5.310 3.750 4.410
2.970 5.180 3.640 5.060
2.120 5.630 3.850 4.170
1.880 4.110 3.900 3.270
2.600 4.490 3.910 3.410
2.160 3.370 3.900 2.520
1.600 2.640 3.960 1.080
1.840 2.910 4.000 1.160
1.600 3.400 3.620 2.240
1.940 4.380 3.730 3.060

2.864
2.864375

3.373753647039
MS F Significance F
3.0694462 9.979715226814 0.0015
0.3075685

t Stat P-value Lower 95% Upper 95%


-0.3140567202 -0.314057 0.7606355742 -24.996247869 18.901847342
0.92558030902 0.9255803 0.378814204122 -0.1343630659 0.3204560807
1.52148988035 1.5214899 0.162463494282 -0.1218190313 0.6223040068
-0.5929809144 -0.592981 0.567793407147 -0.488502076 0.285589012
2.84823515862 2.8482352 0.019144218918 0.23335814567 2.0348002899
2.51380360649 2.5138036 0.033103511096 0.03788985685 0.7191060093
-2.0971997398 -2.0972 0.065414847672 -4.3059925642 0.1629381243
Actual Predicted

Y Y cap Y cap e
1.270 1.314 0.100 -0.044
1.390 1.401 0.300 -0.011
3.200 2.770 0.500 0.430
3.120 3.256 0.700 -0.136
3.190 3.709 0.830 -0.519
3.280 3.748 0.650 -0.468
4.410 4.524 0.100 -0.114
5.060 4.649 0.300 0.411
4.170 3.333 0.500 0.837
3.270 2.437 0.700 0.833
3.410 3.765 0.830 -0.355
2.520 2.352 0.650 0.168
1.080 1.144 0.100 -0.064
1.160 1.600 0.300 -0.440
2.240 2.567 0.500 -0.327
3.060 3.259 0.700 -0.199

2.8644 2.864
1.2277784747
2.4555569494

827.73
827.96

-0.23
Lower 95.0%
-24.996247869
-0.1343630659 2.1314495456
-0.1218190313 2.1314495456
-0.488502076
0.2333581457
0.0378898569
-4.3059925642
y mean EV UEV

y bar Explained Variance Unexplained Variance


2.864 2.402 0.00198
2.864 2.141 0.00013
2.864 0.009 0.18522
2.864 0.154 0.01860
2.864 0.713 0.26930
2.864 0.781 0.21890
2.864 2.753 0.01294
2.864 3.186 0.16860
2.864 0.220 0.69975
2.864 0.183 0.69399
2.864 0.811 0.12597
2.864 0.262 0.02813
2.864 2.959 0.00412
2.864 1.597 0.19403
2.864 0.089 0.10666
2.864 0.156 0.03980
0.17301
18.4166771201748 2.94112391918927
EV UEV

0.862292755992597 0.137707244007403
86.93% 13.06%
3.37375364703921
Error
0.000
-0.044
-0.011
0.430
-0.136
-0.519
-0.468
-0.114
0.411
0.837
0.833
-0.355
0.168
-0.064
-0.440
-0.327
-0.199

21.3578 0.862293
TV R Square

Adj R square0.770488
Year Dominant specialization Vertical integration Import dependence
R&D intensity
Export competitiveness
Capital intensity
Post-tax profit margin
(X1) (X2) (X3) (X4) (X5) (X6) (Y)
1974-75 70.58 22.03 18.29 1.48 3.61 4.3 1.27
1975-76 75.39 21.93 18.56 1.7 4.38 4.71 1.39
1976-77 74.43 23.6 16.77 1.81 5.88 4.63 3.2
1977-78 73.51 21.27 15.16 1.77 7.8 4.48 3.12
1978-79 74.78 20.04 15.43 1.96 6.92 4.1 3.19
1979-80 71.73 19.34 16.92 2.62 6.11 4 3.28
1980-81 72.34 18.27 17.92 3.39 5.31 3.75 4.41
1981-82 73.14 18.91 16.06 2.97 5.18 3.64 5.06
1982-83 76.31 17.33 15.93 2.12 5.63 3.85 4.17
1983-84 75.4 17.72 15.52 1.88 4.11 3.9 3.27
1984-85 75.37 18.76 14.23 2.6 4.49 3.91 3.41
1985-86 73.03 18.32 16.03 2.16 3.37 3.9 2.52
1986-87 74.66 17.56 17.35 1.6 2.64 3.96 1.08
1987-88 77.51 16.79 16.44 1.84 2.91 4 1.16
1988-89 77.32 17.76 16.04 1.6 3.4 3.62 2.24
1989-90 77.3 18.14 15.34 1.94 4.38 3.73 3.06

2.864375
2.864375
SUMMARY OUTPUT
3.373754
Regression Statistics
Multiple R 0.932381219141663
R Square 0.869334737808094
Adjusted R Square 0.78222456301349
Standard Error 0.554588599256261
Observations 16

ANOVA
df SS MS F Significance F
Regression 6 18.41668 3.069446 9.979715 0.001503
Residual 9 2.768117 0.307569
Total 15 21.18479

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


Intercept -3.04720026373722 9.702707 -0.314057 0.760636 -24.99625 18.90185
Dominant specialization 0.093046507390564 0.100528 0.92558 0.378814 -0.134363 0.320456
Vertical integration 0.250242487755248 0.164472 1.52149 0.162463 -0.121819 0.622304
Import dependence -0.1014565319948 0.171096 -0.592981 0.567793 -0.488502 0.285589
R&D intensity 1.13407921778359 0.398169 2.848235 0.019144 0.233358 2.0348
Export competitiveness 0.378497933078733 0.150568 2.513804 0.033104 0.03789 0.719106
Capital intensity -2.07152721996621 0.987759 -2.0972 0.065415 -4.305993 0.162938

0.92558
1.52149
Post-tax profit marginActual Predicted y mean EV UEV Error
Y Y cap e y bar Explained Unexplained Variance 0
1.27 1.314472 -0.044472 2.864375 2.402199 0.001978 -0.044472
1.39 1.401223 -0.011223 2.864375 2.140814 0.000126 -0.011223
3.2 2.769628 0.430372 2.864375 0.008977 0.18522 0.430372
3.12 3.256387 -0.136387 2.864375 0.153674 0.018602 -0.136387
3.19 3.708942 -0.518942 2.864375 0.713294 0.269301 -0.518942
3.28 3.747872 -0.467872 2.864375 0.780567 0.218904 -0.467872
4.41 4.523739 -0.113739 2.864375 2.753488 0.012937 -0.113739
5.06 4.64939 0.41061 2.864375 3.18628 0.1686 0.41061
4.17 3.33349 0.83651 2.864375 0.220069 0.699749 0.83651
3.27 2.436937 0.833063 2.864375 0.182703 0.693994 0.833063
3.41 3.764928 -0.354928 2.864375 0.810995 0.125974 -0.354928
2.52 2.352273 0.167727 2.864375 0.262248 0.028132 0.167727
1.08 1.144153 -0.064153 2.864375 2.959165 0.004116 -0.064153
1.16 1.600486 -0.440486 2.864375 1.597414 0.194028 -0.440486
2.24 2.566591 -0.326591 2.864375 0.088676 0.106661 -0.326591
3.06 3.259488 -0.199488 2.864375 0.156115 0.039796 -0.199488
0.173007
2.864375 2.864375 18.41668 2.941124 21.3578 0.862293
1.227778 EV UEV TV R Square
2.455557

0.862293 0.137707
827.73 0.86933 0.1306
827.96

-0.23 Adj R squa 0.770488

3.373754

Lower 95.0%
-24.99625
-0.134363 2.13145
-0.121819 2.13145
-0.488502
0.233358
0.03789
-4.305993

You might also like