Question (10): Data for 50 U.S. "states" was used to examine the relationship between violent crime rate (violent crimes

[answerhappygod]

Question 10 Data For 50 U S States Was Used To Examine The Relationship Between Violent Crime Rate Violent Crimes 1 (64.58 KiB) Viewed 111 times

Question (10): Data for 50 U.S. "states" was used to examine the relationship between violent crime rate (violent crimes per 100,000 persons per year) and the independent variables of urbanization (percentage of the population living in urban areas) and poverty rate. A 50 observations were examined. The Excel sheet output for the analysis of this data is shown in the Figure. Answer the following questions: (note: you should show step by step procedures) a) Test for significance of all regression parameters using a=0.01: b) If you know that in 2020 the percentage of urbanization was 0.5, while no poverty recorded, what would be the rate of violent crimes (per 100,000 persons per year) that year? (10 points) SUMMARY OUTPUT Regression Statistics Multiple R 0.837 R Square 0.700 Adjusted R Square 0.69 Standard Error 8.54 Observations 50 ANOVA F 54.9 Significance F 0.000 Regression Residual Total df 2 47 49 MS 1030 18.77 SS 2060 882 2942 BO B: 82 Coefficients Standard Error 31.9 148.2 -4.6 1.654 39.3 13.52 Star -2.17 2.83 2.91 P value 0.035 0.007 0.006