Assignment # 04

Submitted to: Dr. Ghulam Ghouse

Submitted by: M. Bilal Makhdoom
Reg no: 70080899
Program: BS (Economics)
Semester: VI
Subject: Econometrics-I
Date: 20/March/2022
Department: Economics
University of Lahore
 Data Set 1
Sr # FDI(inf) Edu
1 0.411511 5.10486
2 0.329327 5.68926
3 0.449506 6.12268
4 0.283812 6.17467
5 0.316965 5.19013
6 0.133245 5.10217
7 0.002822 5.25928
8 0.273716 5.16214
9 0.329355 4.57782
10 0.634851 4.75733
11 0.547125 4.51049
12 0.9833 4.30316
13 1.25321 4.111936
14 1.552547 4.82497
15 1.547361 4.8744
16 0.857714 4.73481
17 0.828039 4.73481
18 2.75709 4.73481
19 0.738436 5.11554
20 1.986389 5.14016
21 1.097744 5.193312
22 7.158102 5.285013
23 1.137291 5.395053
24 4.442277 5.527102
25 1.498214 5.609414
26 2.679706 5.703265
27 3.58502 5.805256
28 3.575095 5.909304
29 2.666048 5.34215
30 2.12097 5.26064
31 1.330904 5.190885
32 2.487275 5.088409
33 2.892094 4.94504
34 3.146164 4.752187
35 3.20253 4.634195
36 3.214983 4.508906
37 2.084338 4.37251
38 2.443511 4.22933
39 3.00127 4.086188
40 1.437611 3.952988
 41 1.084627 3.816747

SUMMARY OUTPUT Data Set 1

Regression Statistics
0.041784
Multiple R 8
0.001745
R Square 97
-
Adjusted R 0.023850
Square 3
Standard 1.463929
Error 69
Observation
s 41

ANOVA
Significan
df SS MS F ce F
0.14618 0.06821
Regression 1 0.146184 4 2 0.795333
Residual 39 83.58052 2.14309
Total 40 83.7267

Coefficien Standard Lower Upper Lower Upper

ts Error t Stat P-value 95% 95% 95.0% 95.0%
-
1.242365 0.61295 0.54346 5.34202 2.8572 5.34202
Intercept 6 2.026835 9 2 -2.85729 6 9 6
-
0.105281 0.26117 0.79533 0.92064 0.7100 0.92064
Edu 24 0.403108 4 3 -0.71008 3 8 3
 FDI (Inf), Edu
7

4
Edu
3
Linear (Edu)
2

0
0 2 4 6 8

Interpretation:
1. The value of Education (Slope) is positive which shows that there’s positive relationship
between both variable (FDI(inf) and Education)
2. The P-value of Education (Slope) is 0.795 which is greater than level of significance 0.05
that’s why Education (Slope) is insignificant.
3. If we increase one unit of Education (Slope) the Education value (Intercept) will increase 1.2
units.
4. R-square is 0.0017459, it means that the independent variable explain 0.17459% variation of
dependent variable and remaining 99.9% explain errors.

Data Set 2
Sr # LnR exp LnR imp
1 21.61938 22.0506
2 21.56511 22.06886
3 21.451 22.06256
 4 21.4533 21.91781
5 21.49795 21.99603
6 21.49411 21.98031
7 21.61035 21.97054
8 21.75221 22.07509
9 22.01085 22.20112
10 21.92643 22.33818
11 22.16526 22.56975
12 22.17786 22.55801
13 22.10394 22.6277
14 22.03046 22.52864
15 22.10305 22.60282
16 22.27351 22.78694
17 22.28051 22.75514
18 22.26594 22.70508
19 22.26379 22.77383
20 22.30538 22.8213
21 22.30437 22.92623
22 22.2717 22.8681
23 22.35216 22.9451
24 22.43344 23.13926
25 22.59253 23.38175
26 22.71498 23.53855
27 22.80749 23.68766
28 23.01425 23.97959
29 23.44799 24.3247
30 22.93878 24.05645
31 23.23363 24.11196
32 23.49246 24.34314
33 23.55601 24.38367
34 23.62807 24.40848
35 23.71785 24.43762
36 23.64744 24.22904
37 23.67055 24.32561
38 23.7916 24.40136
39 23.92681 24.52709
40 23.92985 24.51799
41 23.88719 24.39119
SUMMARY OUTPUT Data Set 2

Regression Statistics
0.984756
Multiple R 2
0.969744
R Square 77
Adjusted R 0.968968
Square 99
Standard 0.141756
Error 8
Observation
s 41

ANOVA
Significan
df SS MS F ce F
1250.03
Regression 1 25.1194 25.1194 3 3.06E-31
0.02009
Residual 39 0.783705 5
Total 40 25.90311

Coefficien Standard Lower Upper Lower Upper

ts Error t Stat P-value 95% 95% 95.0% 95.0%
2.748683 4.89703 1.73E- 1.61335
Intercept 63 0.561295 9 05 1.613357 3.88401 7 3.88401
0.855520 35.3558 3.06E- 0.90446 0.80657 0.90446
LnR imp 16 0.024197 1 31 0.806576 4 6 4
 LnR exp, LnR imp
25

24.5

24

23.5
LnR imp
23
Linear (LnR imp)
22.5

22

21.5
21 21.5 22 22.5 23 23.5 24 24.5

Interpretation:
1. The value of Exports (Slope) is positive which shows that there’s positive relationship
between both variable (Imports and Exports)
2. The P-value of Exports (Slope) is 3.06 which is greater than level of significance 0.05 that’s
why Exports (Slope) is insignificant.
3. If we increase one unit of Imports (Slope) the Exports value (Intercept) will increase 2.74
units.
4. R-square is 0.968, it means that the independent variable explain 96% variation of dependent
variable and remaining 4% explain errors.

Data Set 3
Sr # GDP FDI(inf)
1 2.17E+10 0.411511
2 1.78E+10 0.329327
3 1.77E+10 0.449506
4 1.63E+10 0.283812
5 1.48E+10 0.316965
 6 1.5E+10 0.133245
7 1.95E+10 0.002822
8 2.18E+10 0.273716
9 2.57E+10 0.329355
10 2.63E+10 0.634851
11 3.02E+10 0.547125
12 3.23E+10 0.9833
13 3.37E+10 1.25321
14 3.17E+10 1.552547
15 3.56E+10 1.547361
16 3.9E+10 0.857714
17 4.32E+10 0.828039
18 3.91E+10 2.75709
19 4.18E+10 0.738436
20 4.16E+10 1.986389
21 3.89E+10 1.097744
22 3.95E+10 7.158102
23 4.22E+10 1.137291
24 5.21E+10 4.442277
25 5.96E+10 1.498214
26 6.23E+10 2.679706
27 6.86E+10 3.58502
28 7.9E+10 3.575095
29 9.25E+10 2.666048
30 9.29E+10 2.12097
31 9.32E+10 1.330904
32 1.01E+11 2.487275
33 9.83E+10 2.892094
34 1.07E+11 3.146164
35 1.10E+11 3.20253
36 1.01E+11 3.214983
37 1.03E+11 2.084338
38 1.10E+11 2.443511
39 1.18E+11 3.00127
40 1.20E+11 1.437611
41 1.13E+11 1.084627
SUMMARY OUTPUT Data Set 3

Regression Statistics
0.489230
Multiple R 76
0.239346
R Square 74
Adjusted R 0.219842
Square 81
Standard 3.1347E+
Error 10
Observation
s 41

ANOVA
Significan
df SS MS F ce F
1.21E+2 12.2717
Regression 1 1.21E+22 2 2 0.00117
9.83E+2
Residual 39 3.83E+22 0
Total 40 5.04E+22

Coefficien Standard Lower Upper Lower Upper

ts Error t Stat P-value 95% 95% 95.0% 95.0%
3.6509E+ 3.34E- 5.23E+1 2.08E+1 5.23E+1
Intercept 10 7.79E+09 4.68738 05 2.08E+10 0 0 0
1.2001E+ 3.50310 1.89E+1 5.07E+0 1.89E+1
FDI(inf) 10 3.43E+09 1 0.00117 5.07E+09 0 9 0
 GDP, FDI(inf)
8
7
6
5
4 FDI(inf)

3 Linear (FDI(inf))

2
1
0
0 5E+10 1E+11 1.5E+11

Interpretation:
1. The value of GDP (Slope) is positive which shows that there’s positive relationship between
both variable (GDP and Inflation)
2. The P-value of Inflation (Slope) is 0.00117 which is smaller than level of significance 0.05
that’s why Inflation (Slope) is significant.
3. If we increase one unit of GDP (Slope) the Inflation value (Intercept) will increase 3.6 units.
4. R-square is 0.23, it means that the independent variable explain 23% variation of dependent
variable and remaining 77% explain errors.