Question

1.GDP Population Inflation interest rate
78 14 111 0.09
88 15 112 0.1
45 25 113 0.12
65 32 114 0.14
98 25 112 0.06
88 45 112.5 0.05
85 47 114 0.111
68 85 107.5 0.124
92 66 107 0.123
81 63 106 0.147
79 54 105.5 0.159
77 87 105 0.25
73 25 104 0.16
76 45 110 0.12
66 30 102 0.08
80 50 100 0.09
Considering GDP as dependent variable and other variables as independent variables
1) Apply multiple regression for the above data and copy the Excel output
2) Indicate intercept, and all slope coefficients
3) interpret coefficients
4) State coefficients are significant or not at 5%?
5) Write the coefficient of determination
6) State overall model is fit or not considering the F-test
7) Copy first five residuals and predicted GDP values

( I WANT THE ANS IN EXCEL )

Answer 1

1] Excel multiple regression output is attached below

2] intercept = 73.9639,

slope for polpulation =0.1710

slope for inflation =0.0816

​​​​​​​ slope for interest rate = -107.6273

3] for every one unit increase in population , the predicted GDP will increases by 0.1710

for every one unit increase in inflation , the predicted GDP will increases by 0.0816

for every one unit increase in interest rate , the predicted GDP will decreases by 1.076273

4]the p-value for all the independant(predictor) variables are greater than 0.05 , this indicates that all the predictor variables are not significant to the model.

5] coefficient of determination R2= 0.1250

6] To test overall significance of the model

Test statistics = 0.5713

p-value = 0.6446 > 0.05

this indicates that the overall regression model is not significant

7]

Residuals

2.274

13.097

-29.542

-8.668

17.082