Good Afternoon I have completed the requested questions on section 1 a on excel however I am having a bit of trouble analysing this data and awnsering 1 b and it's sub questions. please help me solve these 3 sub questions Please find the 1980's data attached by itself and the current day data attached with my excel workings.(x) This is updated data for the 14 countries studied in the in-class mock exam. Compare the regression equation from the 1980s data used in the exam with this data from 2019 and comment on one similarity and one difference between the two time periods.(xi) If the GNP per capita of Malawi were to increase by US$ 1000, what would you expect its birth rate to be? Show all workings.(xii) Using the Rsquared from the regression output calculate the correlation coefficient manually. Show all workings.The comment must be done on the work I have already done on excel. Please help,thank you. GNP per capCountryBangladeshTanzaniaBirth Rate14047280471980'S DATA AND EQ.Sierra LeoneSudan3204638047KenyaIndonesia420555303519102560Panama30Chile25Venezuela422035TurkeyMalaysiaNepalMalawi1540331840311504420056Argentina256020mean1217.85714339.35714286standard deviation 1253.33511111.02170685|correlation coeffici -0.730642881a. The equation for a line of regression, ŷ = a + bx, is:bırth rate = a + bgnpwhere gnp is the explanatory variable for the birth rate, the response variable. Using the summary statistics given above, show how to calculate both the slope coefficient and the intercept (do not round any numbers until the end). Show all working out.The estimates of a and b (correct to 4 d.p.) from the above dataset are:a = 47.1821b = - 0.0064 enezuelaanama1 Country2 BangladeshTanzaniaGNP per cap Birth Rate5200Chart Titley0.001ix+30.5441832700364 Sierra Leone5 Sudan6 Kenya177033399032443029- Indonesia1197015730718Comment on the scatterplot: orm, strength, direction, outliers.Demonstrate how to calculate the slope of the regression line manually,using the summary statistics you generated in excel (correlationcoefficient, standard deviation of y and standard deviation of x). Show allworkings.Now calculate the intercept, manually. Show all workings.Write out the regression equation, (you can check that your manualcalculations match the regression output in excel).Form a hypothesis about the effect of GNP per capita on birth rate andstate the hypothesis. Test the hypothesis at a significance level of 0.05.Write out the formula to calculate the T stat, and manually calculate the Tstat. The distribution to test for the coefficient is I distribution n-2tion A()(i)8 Panama9 Chile10 Venezuela11 Turkey12 Malaysia13 NepalMalawi15 Argentina1617 Mean10191. Data on GNP per capita and Birth Rate (births per thousand inhabitants) for a sampleof 14 countries for 2019 is displayed below:1489016054121820004000600080001000012000140001600018000GNP per Capita(i)(iv)912016GNPBirth1141015ountryangladeshper cap Rate(v)10701952001841034SUMMARY OUTPUT14anzania270036(vi)991017jerraRecression SiatisticsMultiple R 0.775729degrees of freedom. Show all workings.eone177033(vii) Look up the T table and verify the P value. What line along the T table7761 22.57142857udanshould you use to check the p value for the t stat?18 St Dev19 Correlation Coeficient399032(viii) Write out how to calculate the residual for Nepal (you can check your5634.950153 8.234208997RSquare0.601755enva443029manual result matches the excel output). Show all workings.-0.738279458 -0.738279458Adjusted F 0.565551Standard E 5,576425Observaticidonesia(ix)Comment on the residual.20211197018(x)This is updated data for the 14 countries studied in the in-class mockexam. Compare the regression equation from the 1980s data used in theexam with this data from 2019 and comment on one similarity and onedifference between the two time periods.If the GNP per capita of Malawi were to increase by US$ 1000, what1315730192223hile1489012ANOVA1605618vificarce F0.0018324252627ofMS516.8614F(xi)urkeylalaysiaеpallalawiRegressionResidualTotal9120161516.861416.6212would you expect its birth rate to be? Show all workings.11342.0617 31096521141015Using the Bsquared from the regression output calculate the correlationcoefficient manually. Show all workings.(xii)12858.923110701928(xiii) This dataset is not necessarily random. Is GNP per capita a good way todetermine a country's birth rate? Comment with reference to two293031Coefficientantard En Sa31905165200 -0.001129 0.000277Pvalue Lower S5%Loper 95%.ower 25 0pper 25 0%11.85259 1.32E-07 25.98048 37.82984 25.98048 37.829840.00183 -0.001738 -0.000519 -0.001738 -0.00051941034rgentina991017Intercept2.69183countries from this dataset.-4.07691323334a. Copy the data into excel. (Or use the excel file containing the data uploaded toMoodle)35RESIDUAL OUTPUT36CbservatiovFredcted R Residuals1 28.85771(1)Generate summary statistics for correlation coefficient and mean andstandard deviation for each variable.Generate a scatterplot of birth rate vs gnp per capita.Generate the line of best fit where gop is the explanatory variable forbirth rate, the response variable.Display equation for line of best fit on the graph.Display R squared on the graph.Generate regression summary.37383940417.142293(ii)(i)2 29.90739 3.092615327.4017 4.59829726.9050818.39479 -0.39478942.094919(iv)(V)(vi)42543614.150934.8490744454615.09903 -3.0990268 13.78524 4.21476421.61154 -5.61154419.02685 -4.0268537471048495030.69747 -1169747121131.4424 2.5576021320.71988 -3.719882

Simple linear regression model: A simple linear regression model is given as y^ = b0 + bx + e…

Answered: lease find the 1980's data attached by…

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P