CM FLR PGNP 128 37 1870 204 22 130 202 16 310 197 65 570 96 76 2050 209 26 200 1
ID: 3200644 • Letter: C
Question
CM
FLR
PGNP
128
37
1870
204
22
130
202
16
310
197
65
570
96
76
2050
209
26
200
170
45
670
240
29
300
241
11
120
55
55
290
75
87
1180
129
55
900
24
93
1730
165
31
1150
94
77
1160
96
80
1270
148
30
580
98
69
660
161
43
420
118
47
1080
269
17
290
189
35
270
126
58
560
12
81
4240
167
29
240
135
65
430
107
87
3020
72
63
1420
128
49
420
27
63
19830
152
84
420
224
23
530
142
50
8640
104
62
350
287
31
230
41
66
1620
312
11
190
77
88
2090
142
22
900
262
22
230
215
12
140
246
9
330
191
31
1010
182
19
300
37
88
1730
103
35
780
67
85
1300
143
78
930
83
85
690
223
33
200
240
19
450
312
21
280
12
79
4430
52
83
270
79
43
1340
61
88
670
168
28
410
28
95
4370
121
41
1310
115
62
1470
186
45
300
47
85
3630
178
45
220
142
67
560
Child Mortality in relation to per capita GDP and female literacy rate
In this worksheet you are given cross-sectional data for 64 countries on child mortality(CM) and a few other variables - FLR female literacy rate and PGNP = per capita GNP in 1980.
CM = Child mortality, the number of deaths of children under age 5 in a year per 1000 live births.
FLF = Female literacy rate, percent.
PGNP = per capita GNP in 1980.
We are going to estimate the following regression
CMt=B + B FLFt + B PGNPt + Ut
a) Before you perform the regression model make a personal prediction about the expected signs of the parameters B2 and B3 and justify your answers
b) Estimate the regression model in Excel
c) Interpret the estimated parameters (intercept term, B and B). Not just the sign but also the whole value of the parameter
d) Comment on R² Explain what means about the model and also if is an acceptable value for what it express
e) Comment on the statistical significance of each of the estimated parameters , Are the variables significant at a 5% level of significance?
F) Is the model significant at a 5% level of significance? Justify your answer
CM
FLR
PGNP
128
37
1870
204
22
130
202
16
310
197
65
570
96
76
2050
209
26
200
170
45
670
240
29
300
241
11
120
55
55
290
75
87
1180
129
55
900
24
93
1730
165
31
1150
94
77
1160
96
80
1270
148
30
580
98
69
660
161
43
420
118
47
1080
269
17
290
189
35
270
126
58
560
12
81
4240
167
29
240
135
65
430
107
87
3020
72
63
1420
128
49
420
27
63
19830
152
84
420
224
23
530
142
50
8640
104
62
350
287
31
230
41
66
1620
312
11
190
77
88
2090
142
22
900
262
22
230
215
12
140
246
9
330
191
31
1010
182
19
300
37
88
1730
103
35
780
67
85
1300
143
78
930
83
85
690
223
33
200
240
19
450
312
21
280
12
79
4430
52
83
270
79
43
1340
61
88
670
168
28
410
28
95
4370
121
41
1310
115
62
1470
186
45
300
47
85
3630
178
45
220
142
67
560
Explanation / Answer
Here' are answers to the question:
a) Just be looking at the data we can see that FLR has a negative movement with CM.
PGNP' movement with CM seems indecisive.
b) CM = FLR + PGNP
CM = 263.64 -2.23159*FLR - .00565*PGNP
c) For 1 unit rise in Female Literacy Rate (FLR) the child mortality decreses by 2.23 dealth per thousand
For 1 unit rise in PGNP the CM decreases by 0.00565 units.
d) R2 square of .707 means that 70.7 of the varinace in data is been explained by the 2 variables.
e) The significance level of FLR and PGNP are very less .05 ( at 1.64*E-15 and .0065). Hence, both the variables are significant in the equation.
f) The regression equation' p value is 5.12 E-17 which is almost 0. Hence, smaller than the cutoff value of .05. The linear regression eauation is therefore significant.