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 𝜶 = 𝟎.𝟎𝟏:
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 1 (33.91 KiB) Viewed 103 times
SUMMARY OUTPUT Regression Statistics Multiple R 0.837 R Square 0.700 Adjusted R Square 0.69 Standard Error 8.54 Observations 50 ANOVA SS MS df 2 F 54.9 Significance F 0.000 2060 1030 Regression Residual Total 47 882 18.77 49 2942 t Stat Coefficients 31.9 -4.6 BO B1 (urbanization) B2 (Poverity) Standard Error 148.2 1.654 P-value 0.035 -2.17 2.83 2.91 0.007 39.3 13.52 0.006
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!