In New Jersey, banks have been charged with withdrawing from counties having a high percentage of minorities. To substantiate this charge, P. D€™Ambrosio and S. Chambers (1995) present the data in the page margin concerning the percentage, x, of minority population and the number of county residents, y, per bank branch in each of New Jersey€™s 21 counties. If we use Excel to perform a simple linear regression analysis of this data, we obtain the output given in Figure 13.38 on the next page.

a. Determine if there is a significant relationship between x and y.
b. Describe the exact nature of any relationship that exists between x and y.

Transcribed Image Text:

Regression Staustics Multiple R R Square Adjusted R Square tandard Error Observations ANOVA Regression Residual Total 0.7256 0.5265 0.5016 400.2546 21 df F Signlficance F 0.0002 MS 3385090234 3385090 21.1299 19 20 coefficients 2082.0153 35.2877 3043870.432 160203.7 6428960.667 standard Error 7.6767 P-value 159.1070 13.0856 5.92E-11 4.5967 0.0002 t Stat Intercept 96 Minority Pop (x) Lower 95% 1749.0005 19.2202 Upper 95% 2415.0301 51.3553