There are three steps:
1) Provide a linear regression using the data in attached file using Excel Add On software program Regression data analysis. Save the results next to the two other regressions, as they need to be confirmed and whether the two y independent variables should be run differently Provide a three page explanation of the actual regression and the significance of the values, e.g. rsquared and fstat. .As part of this examine and see whether they are statistically significant through the regression statistics for both y1 and y2 ; if the coefficient is sufficiently greater than 0 or less than 0 we can confidently state that the coefficient is statistically significant. While interpreting the explanatory variables (x) determine whether it has a direct effect on the dependent variables (y) when b ≠ 0. In addition, interpret and explain the other regression statistics and its importance.
2) Though these variables are significant to the overall crime rate for these cities, this analysis will be limited due to the lack of variables. There are many limitations to analyzing the overall crime rate in these cities; discuss various variables in additional that would provide a stronger correlation and significance to the dependent variable. These include gun laws, gun sales, unemployment rates, and inflation. Include this in the write up as a separate section.
3) COMPOSE a conclusion, How the original data is weak and requires other variables and categories of data beyond education.