Question
(a) Using the data above (link is present), please run a regression with GDP as the as the dependent (Y) variable and all other variables
(a) Using the data above (link is present), please run a regression with GDP as the as the dependent (Y) variable and all other variables are the independent (X) variables -
Population density,
Prevalence of child malnutrition,
Maternal mortality ratio,
Under-five mortality rate,
Incidence of tuberculosis,
Mortality caused by road traffic injury,
Primary completion rate,
Labor productivity
Please copy and paste your Excel output into your answer.
(b) What can you say about the goodness of fit of the equation? Please explain.
(c) Which independent variables have a significant coefficient in the regression? Please explain.
(d) Based on the results of your regression only, do you think that the quality of life (as measured by the independent variables) have an impact on growth rate of real GDP per capita? Please explain.
(e) Is it possible that in addition to the independent variables in the above regression having an impact on GDP, the GDP also has an impact on the independent variables, i.e., it is not just the (X) variable that determine GDP, but GDP also determines the X variables? Please explain why this might happen (this is not a statistical explanation but an analysis of the variables.
(f) Please run a regression with Prevalence of child malnutrition as the dependent (Y) variable and GDP as the independent (X) variable. Does GDP have an impact on child malnutrition? Please explain.