Question 1: For analysing the model in which the poverty rate can be estimated as a linear combination of the infant mortality rate, the percentage of the population that is white and the violent crime rate per 100,000 people, a sample of 50 persons was collected from a population and produced the following multiple regression analysis output SUMMARY OUTPUT M SEOSE Rsquare Afted some 02954838 Standard 2.4702001 Ons 53 1 O 47535757 TRO033 46 28.644684203 Intercept 04371259053301023 S 55 STY 2005 ort 12290625 0.10072909 2592.36 10.8 0.47185208 23 DO 1000 02200336612 GOOGLE BOOBS 2603256 Use the above Excel results to answer the following questions a. What are the dependent and independent variables in words]? b. Use the above Excel outputs to estimate the multiple linear regression equation Interpret each one of the estimated regression coefficients po, p1, 52 and 53. d. What is the value of the linear correlation coefficient? Use this value to comment on whether you think a linear relationship exists between the dependent and independent variables. e Identify and interpret the coefficient of determination Test the significance of the regression model at the level Does each one of the explanatory variables de a good job of explaining changes in the poverty rate? Explain why or why not h. Predict the chance of poverty rate for this population if the infant mortality rate is 0.16% the percentage of the population that is white is 20% and the violent crime rate per 100,000 people) Question 1: For analysing the model in which the poverty rate can be estimated as a linear combination of the infant mortality rate, the percentage of the population that is white and the violent crime rate per 100,000 people, a sample of 50 persons was collected from a population and produced the following multiple regression analysis output SUMMARY OUTPUT M SEOSE Rsquare Afted some 02954838 Standard 2.4702001 Ons 53 1 O 47535757 TRO033 46 28.644684203 Intercept 04371259053301023 S 55 STY 2005 ort 12290625 0.10072909 2592.36 10.8 0.47185208 23 DO 1000 02200336612 GOOGLE BOOBS 2603256 Use the above Excel results to answer the following questions a. What are the dependent and independent variables in words]? b. Use the above Excel outputs to estimate the multiple linear regression equation Interpret each one of the estimated regression coefficients po, p1, 52 and 53. d. What is the value of the linear correlation coefficient? Use this value to comment on whether you think a linear relationship exists between the dependent and independent variables. e Identify and interpret the coefficient of determination Test the significance of the regression model at the level Does each one of the explanatory variables de a good job of explaining changes in the poverty rate? Explain why or why not h. Predict the chance of poverty rate for this population if the infant mortality rate is 0.16% the percentage of the population that is white is 20% and the violent crime rate per 100,000 people)