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 (i) Comment on the scatterplot: form, strength, direction, outliers.(ii) Demonstrate how to calculate the slope of the regression line manually, using the summary statistics you generated in excel (correlation coefficient, standard deviation of y and standard deviation of x). Show all workings.(iii) Now calculate the intercept, manually. Show all workings. The comment must be done on the work I have already done on excel. Please help,thank you. Section A(i)(ii)Comment on the scatterplot: form, 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 T1. Data on GNP per capita and Birth Rate (births per thousand inhabitants) for a sampleof 14 countries for 2019 is displayed below:(iii)(iv)GNPBirthCountryper capRate(v)Bangladesh520018Tanzania270036(vi)stat. The distribution to test for the coefficient is T distribution n-2Sierradegrees of freedom. Show all workings.Leone177033(vii) Look up the T table and verify the P value. What line along the T tableshould you use to check the p value for the t stat?(viii) Write out how to calculate the residual for Nepal (you can check yourSudan399032Kenya443029manual result matches the excel output). Show all workings.Indonesia1197018(ix)Comment on the residual.(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, whatPanama1573019Chile1489012Venezuela1605418(xi)TurkeyMalaysiaNepal912016would you expect its birth rate to be? Show all workings.(xii) Using the Bsquared from the regression output calculate the correlationcoefficient manually. Show all workings.1141015107019(xii) This dataset is not necessarily random. Is GNP per capita a good way toMalawi41034Argentinadetermine a country's birth rate? Comment with reference to twocountries from this dataset.991017Copy the data into excel. (Or use the excel file containing the data uploaded toMoodle)(i)a.Generate summary statistics for correlation coefficient and mean andstandard deviation for each variable.(ii)(ii)Generate a scatterplot of birth rate vs gng per capita.Generate the line of best fit where gng is the explanatory variable forbirth rate, the response variable.(iv) Display equation for line of best fit on the graph.(v)(vi)Display R squared on the graph.Generate regression summary. 1 Country2 Bangladesh3 Tanzania4 Sierra Leone5 Sudan6 Kenya7 Indonesia8 Panama9 Chile10 Venezuela11 Turkey12 Malaysia13 Nepal14 Malawi15 Argentina1617 Mean18 St Dev19 Correlation CoeficientGNP per cap Birth Rate5200Chart Titley=0.0011x + 30.944R= 0.54511840270036351770333039903225443029201511970181015730191489012160541818000200040006000800010000120001400016000912016GNP per Capita114101510701941034SUMMARY OUTPUT991017Regression Statistics776122.57142857Multiple R 0.7757295634.950153R Square8.2342089970.601755Adjusted F 0.565551Standard E 5.576425Observatic-0.738279458 -0.7382794582021222313ANOVAizificance F2425262728293031ofRegressionResidualTotal516.8614516.861416.62120.0018311342.061712858.923131.09652Caefficienttandand En31.905165200 -0.001129 0.000277StatFvalue Lower 9oper 95X.ower 950pner 950%1.32E-07 25.98048 37.82984 25.98048 37.829840.00183 -0.001738 -0.000519 -0.001738 -0.000519Intercept2.6918311.85259-4.0769132333435363738394041424344454647484950RESIDUAL OUTPUTCbservativFredicted Residals1 28.85771 7.1422932 29.907393.09261527.4017 4.5982974 26.9050818.39479 -0.3947892.094919614.150934.84907715.09903 -3.09902613.785244.214764921.61154-5.6115441019.02685 -4.02685311 30.69747 -11.697471231.4424 2.5576021320.71988 -3.719882Birth Rate

Name: Good Afternoon I have completed the requested questions on section 1 a
Uploaded: 2024-03-20T07:06:16.000Z
Channel: Bartleby
Description: 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 (i) Comment on the scatter