P11.1011 Statistical Methods for Public, Nonprofit, and Health Management Student's name: Mailbox number: Homework - Class 13 1. The printout on next page shows a multivariate regression of CLEANPCT on POOR, WORKERS, POPDENS, and SUMMONS based on 59 sanitation districts in New York City. The variables have the following meaning for each district: CLEANPCT Percent of streets rated clean by the Sanitation Department POOR Poverty stats [1 if median household income=$10,000] WORKERS Number of sanitation field employees in the district POPDENS Number of residents per acre SUMMONS Number of summonses issued during the year a. Write the sample regression equation. b. Estimate the percentage of streets that are rated clean for a district that has: i. A median income of $18,000 ii. 50 residents per acre iii. 100 field employees iv. 3,000 summonses issued during the year c. Which variables have coefficients that are significant at the.05 level? Class 13 Homework Assignment Page 1 of 3d. What percentage of variation in CLEANPCT is explained by variation in the other four variables? e. Is your equation signicant at the 5% level? Explain in one sentence why you believe thisto be true. f. Controlling for WORKERS, SUMMONS, and POOR, what is the impact of POPDENS on the percentage of streets that are rated clean? g. Controlling for WORKERS, POPDENS, and SUMMONS, what is the difference in cleanliness between a district that has a median household income below $10,000 and one that has a median household income above $10,000? Class 13 Homework Assignment Page 2 of 3 Regression Variables Entered/Removed(b) Mode Variables Entered Variables Removed Method Summonses Issued, Sanitation Dept. Field Enter Employees, Population Density, Poverty Status(a) a All requested variables entered. b Dependent Variable: % of Streets Rated Clean Model Summary Std. Error Mode R Adjusted of the R Square R Square Estimate 1 857(a) 734 -.714 9.020 a Predictors: (Constant), Summonses Issued, Sanitation Dept. Field Employees, Population Density, Poverty Status ANOVA(b) Sum of Mean Mode Squares df Square F Sig. Regression 12099.787 4 3024.947 37.176 .000(a) Residual 4393.89 54 81.368 Total 16493.685 58 a Predictors: (Constant), Summonses Issued, Sanitation Dept. Field Employees, Population Density, Poverty Status b Dependent Variable: % of Streets Rated Clean Coefficients(a) Unstandardized Standardized Model Coefficients Coefficients Std. B Error Beta Sig 1 (Constant) 9.629 5.306 5.008 Poverty Status -18.370 3.117 -.478 -5.893 000 Sanitation Dept. Field 3.302E-02 041 063 .802 426 Employees Population Density -.133 036 .303 -3.718 000 Summonses Issued -3.108E-03 001 -.341 -4.023 000 a Dependent Variable: % of Streets Rated Clean Class 13 Homework Assignment Page 3 of 3