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: yo
- Data For 50 U S States Was Used To Examine The Relationship Between Violent Crime Rate Violent Crimes Per 100 000 Pe 1 (219.72 KiB) Viewed 115 times
a) Test for significance of all
regression parameters using 𝜶 = 𝟎.𝟎𝟏:
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?
- Data For 50 U S States Was Used To Examine The Relationship Between Violent Crime Rate Violent Crimes Per 100 000 Pe 2 (188.89 KiB) Viewed 115 times
Regression Statistics Multiple R 0.837 R Square 0.700 Adjusted R Square 0.69 Standard Error 8.54 Observations 50 ANOVA SS MS F df 2 47 Significance F 0.000 2060 Regression Residual 54.9 1030 18.77 882 Total 49 2942 t Stat P-value -2.17 0.035 Во B1 (urbanization) B2 (Poverity) Coefficients 31.9 -4.6 39.3 Standard Error 148.2 1.654 13.52 2.83 2.91 0.007 0.006 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? 1 A B I E E E 8 $$