Could you please do 2G) I have attached an image for that question. That is the only question that I am finding so confusing. Sorry for the inconvenience appreciate your help. I think you need to do the questions before 2G), in order to be able to do 2G.
I have also included the excel file for the data, that you will need.
lifeexp 0 1 1 0 0 1 1 1 1 1 1 1 1 1 1 0 country_name year Australia Austria Belgium Canada Chile Czech Republic Denmark Estonia Finland France Germany Greece Hungary Iceland Ireland Israel Italy Japan Korea Luxembourg Mexico Netherlands New Zealand Norway Poland Portugal Slovak Republic Slovenia Spain Sweden Switzerland Turkey United Kingdom United States 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 hlthgdp hlthpc 9.1 11.2 10.7 11.4 8.4 8 11.5 7 9.2 11.7 11.7 10.6 7.7 9.6 9.9 7.9 9.3 9.5 6.9 7.9 6.4 11.9 10 9.8 7.2 10.8 9.2 9.3 9.6 9.9 11.4 6.7 9.8 17.7 infmort 3670 4.3 4346 3.8 3911 3.4 4317 5 1210 2048 2.9 4385 3.1 1385 3.6 3271 2.6 3930 3.9 4225 3.5 3106 3.1 1559 5.1 3539 1.8 3944 3.2 2165 3.8 3005 3.9 3035 2.4 1864 3.2 4786 2.5 923 14.7 4886 3.8 2923 5.2 5348 3.1 1365 5.6 2697 3.6 2066 5.7 2524 2.4 3076 3.2 3711 2.5 5135 4.3 968 13.1 3379 4.6 7990 6.4 gdppc code 79.3 39040 AUS 77.6 38827.7 AUT 77.3 36721.7 BEL 78.5 37842.3 CAN 75.8 15177.3 CHL 74.2 25627.5 CZR 76.9 38295.5 DEN 69.8 19792.6 EST 76.6 35696.9 FIN 77.7 33548.9 FRA 77.8 36039.6 GER 77.8 29384.3 GRE 70 20156.5 HUN 79.7 36751.6 ICE 77.4 39835.8 IRE 79.6 25472.2 ISR 79.4 32250 ITA 32107 JAP 77 26930.6 KOR 78.1 82900.9 LUX 72.9 13806.2 MEX 78.5 41082.2 NET 78.8 29496.5 NZ 78.7 54693.8 NOR 71.5 18927.1 PER 76.5 24938 POR 71.3 22579.7 SLR 75.8 27179.3 SLO 78.7 32164.4 SPA 79.4 37341.4 SWE 79.9 45108.3 SWI 71.5 14453.6 TUR 78.3 34476.2 UK 76 45191.9 USA hithpesa europe 1.35E+07 1.89E+07 1.53E+07 1.86E+07 1464100 4194304 1.92E+07 1918225 1.07E+07 1.54E+07 1.79E+07 9647236 2430481 1.25E+07 1.56E+07 4687225 9030025 9211225 3474496 2.29E+07 851929 2.39E+07 8543929 2.86E+07 1863225 7273809 4268356 6370576 9461776 1.38E+07 2.64E+07 937024 1.14E+07 6.38E+07 79.6 1 0 0 1 0 1 0 1 1 1 1 1 1 1 1 0 1 0 Question 2 (Note: round your answers to 3 decimals) This question studies the effect of per capita health expenditures on infant mortality. You will need statistical software to complete this question. From UTS:Online -> subject documents -> assignment, download the data set Health2009.csv. The data set contains macroeconomic data on 34 wealthy and relatively wealthy nations in the Organization of Economic Co-operation and Development (OECD). The key variables are described as follows: country_name = Name of the country infmort = Infant mortality (deaths per 1,000) hlthpe = health expenditures per capita (expressed in current US dollars at current exchange rates) Europe = 1 if the country is in Europe, = otherwise (a)(1pt) Use EViews to construct a scatter plot with hithpe as the x-axis and infmort as the y-axis, and put it on your answer sheet. Briefly describe the scatter plot. (b)(1pt) Run an OLS regression of infmort on hlthpe. On your answer sheet, write down the result in a compact format with the SRL, standard errors, t-statistics, p-values, R- squared and degrees of freedom. (c)(1pt) Briefly interpret the coefficients and p-values in the above regression. (d)(1pt) Briefly interpret the R-squared measure in the above regression. Is the model useful? Why (not)? (e)(Ipt) Suppose that the normality assumption of CNLRM is violated. Does it affect the validity of your results? Why (not)? (1/(1pt) Suppose that you are a politician and are concerned about the infant mortality in your country. You consider increasing per capita health expenditures to achieve this. Your country currently spends 4,000 dollars per capita. What is the predicted infant mortality at this level of health expenditures? (g)(2pt) Your political party agrees to support your decision to increase health expenditures per capita by 10% if you can show that the additional 400 dollars expenditures would save (on average) more than 0.2 infants per 1,000 from premature death (ie., infant mortality would decrease by 0.20 per 1,000). How would you formally test if the additional health expenditures would bring about the necessary drop in infant mortality? Write down the null and alternative hypothesis, and the results to all other steps. Is your test result at the 5% significance level such that your political party will support your decision to increase health expenditures by 10%? lifeexp 0 1 1 0 0 1 1 1 1 1 1 1 1 1 1 0 country_name year Australia Austria Belgium Canada Chile Czech Republic Denmark Estonia Finland France Germany Greece Hungary Iceland Ireland Israel Italy Japan Korea Luxembourg Mexico Netherlands New Zealand Norway Poland Portugal Slovak Republic Slovenia Spain Sweden Switzerland Turkey United Kingdom United States 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 hlthgdp hlthpc 9.1 11.2 10.7 11.4 8.4 8 11.5 7 9.2 11.7 11.7 10.6 7.7 9.6 9.9 7.9 9.3 9.5 6.9 7.9 6.4 11.9 10 9.8 7.2 10.8 9.2 9.3 9.6 9.9 11.4 6.7 9.8 17.7 infmort 3670 4.3 4346 3.8 3911 3.4 4317 5 1210 2048 2.9 4385 3.1 1385 3.6 3271 2.6 3930 3.9 4225 3.5 3106 3.1 1559 5.1 3539 1.8 3944 3.2 2165 3.8 3005 3.9 3035 2.4 1864 3.2 4786 2.5 923 14.7 4886 3.8 2923 5.2 5348 3.1 1365 5.6 2697 3.6 2066 5.7 2524 2.4 3076 3.2 3711 2.5 5135 4.3 968 13.1 3379 4.6 7990 6.4 gdppc code 79.3 39040 AUS 77.6 38827.7 AUT 77.3 36721.7 BEL 78.5 37842.3 CAN 75.8 15177.3 CHL 74.2 25627.5 CZR 76.9 38295.5 DEN 69.8 19792.6 EST 76.6 35696.9 FIN 77.7 33548.9 FRA 77.8 36039.6 GER 77.8 29384.3 GRE 70 20156.5 HUN 79.7 36751.6 ICE 77.4 39835.8 IRE 79.6 25472.2 ISR 79.4 32250 ITA 32107 JAP 77 26930.6 KOR 78.1 82900.9 LUX 72.9 13806.2 MEX 78.5 41082.2 NET 78.8 29496.5 NZ 78.7 54693.8 NOR 71.5 18927.1 PER 76.5 24938 POR 71.3 22579.7 SLR 75.8 27179.3 SLO 78.7 32164.4 SPA 79.4 37341.4 SWE 79.9 45108.3 SWI 71.5 14453.6 TUR 78.3 34476.2 UK 76 45191.9 USA hithpesa europe 1.35E+07 1.89E+07 1.53E+07 1.86E+07 1464100 4194304 1.92E+07 1918225 1.07E+07 1.54E+07 1.79E+07 9647236 2430481 1.25E+07 1.56E+07 4687225 9030025 9211225 3474496 2.29E+07 851929 2.39E+07 8543929 2.86E+07 1863225 7273809 4268356 6370576 9461776 1.38E+07 2.64E+07 937024 1.14E+07 6.38E+07 79.6 1 0 0 1 0 1 0 1 1 1 1 1 1 1 1 0 1 0 Question 2 (Note: round your answers to 3 decimals) This question studies the effect of per capita health expenditures on infant mortality. You will need statistical software to complete this question. From UTS:Online -> subject documents -> assignment, download the data set Health2009.csv. The data set contains macroeconomic data on 34 wealthy and relatively wealthy nations in the Organization of Economic Co-operation and Development (OECD). The key variables are described as follows: country_name = Name of the country infmort = Infant mortality (deaths per 1,000) hlthpe = health expenditures per capita (expressed in current US dollars at current exchange rates) Europe = 1 if the country is in Europe, = otherwise (a)(1pt) Use EViews to construct a scatter plot with hithpe as the x-axis and infmort as the y-axis, and put it on your answer sheet. Briefly describe the scatter plot. (b)(1pt) Run an OLS regression of infmort on hlthpe. On your answer sheet, write down the result in a compact format with the SRL, standard errors, t-statistics, p-values, R- squared and degrees of freedom. (c)(1pt) Briefly interpret the coefficients and p-values in the above regression. (d)(1pt) Briefly interpret the R-squared measure in the above regression. Is the model useful? Why (not)? (e)(Ipt) Suppose that the normality assumption of CNLRM is violated. Does it affect the validity of your results? Why (not)? (1/(1pt) Suppose that you are a politician and are concerned about the infant mortality in your country. You consider increasing per capita health expenditures to achieve this. Your country currently spends 4,000 dollars per capita. What is the predicted infant mortality at this level of health expenditures? (g)(2pt) Your political party agrees to support your decision to increase health expenditures per capita by 10% if you can show that the additional 400 dollars expenditures would save (on average) more than 0.2 infants per 1,000 from premature death (ie., infant mortality would decrease by 0.20 per 1,000). How would you formally test if the additional health expenditures would bring about the necessary drop in infant mortality? Write down the null and alternative hypothesis, and the results to all other steps. Is your test result at the 5% significance level such that your political party will support your decision to increase health expenditures by 10%
