Question

eBook DE MATH Hosted by ALEKS Corp Section 10.3 Previous 1 2 3 6 6 7 INN > Next Question 5 of 7 (2 points) View problem in a pop- 10.3 Section Exercise 18 Data for per capita state debt and per capita state tax for nine randomly selected states are shown. The correlation coefficient isr -0.779. Compute the standard error of the estimate, if appropriate. Assume & -0.05. Question Check Answer Solve It Per capita debt x 1016 Per capita tax y 1727 Source: World Almanac. Download data 1913 2049 3377 2432 1446 1860 2650 1720 4529 3478 1902 2054 3691 2069 1455 1948 Guided Solution Show Example Ask My Instructor Link to Textbook Part 1 out of 2 The standard error of the estimate (select) be calculated Tables Formulas Save for Later Submit Assignment Plugin not installed or missing Shoe s

Answer 1

Part 1 out of 2: EXCEL (Data Analysis) output:

SUMMARY OUTPUT Regression Statistics Multiple R 0.779352 R Square 0.60739 Adjusted R Square 0.551303 Standard Error 363.6515 Observations ANOVA df Regression Residual Total SSMSF gnificance F 1 1432104 1432104 10.82938 0.013288 7 925696.6 132242.4 8 2357800 Intercept Per capita debt Coefficientsandard Errt Stat p-value Lower 95%Upper 95% 1283.147 289.5702 4.431213 0.00304 598.4226 1967.872 0.354369 0.107685 3.290803 0.013288 0.099735 0.609003 The standard error of the estimate is 363.6515.