A researcher was interested in the relationship between expenditure onimports($million) and personalincome($ million) for residents in a city. EXCEL was used to create the following simple linear regression output.

Imports and Income Excel Output:

SUMMARY OUTPUT Regression Statistics Multiple R 0.967 R Square 0.936 Adjusted R 0.932 Square Standard 0.932 Error Observations 0.932 ANOVA df 5S MS F Significance Regression 1 130904.793 130904.793 263.121 3.46E-12 Residual 18 8955.157 497.509 Total 19 139859.95 Standard Coefficients t Stat P-value Lower 95% Error Intercept -260.771 32.067 -8.132 0.000 -328.14 Income 0.246 0.015 16.221 0.000 0.214