Question

How does the state of North Carolina compare to the other 49 states? This file State Demographics contains data for all states except North Carolina*. Question 1. Find a regression model for Life Expectancy using the other 3 variables as explanatory variables. Enter the coefficients of each explanatory variable below (use 6 decimal places). coefficient for Murder Rate coefficient for HS Graduation coefficient for Income Question 2. What percent of the variation in Life Expectancy is explained by the differences in the explanatory variables? (express as a percent; use 1 decimal place) % Question 3. Use the multiple regression model to estimate the life expectancy in North Carolina if the values of North Carolina's explanatory variables are Murder Rate=11.1, HS Graduation=38.5, and Income=3875 (use 2 decimal places). years. *VARIABLES INCLUDED IN THE DATA: Murder Rate per 100,000 citizens, HS Graduation rate in percent, Income per capita in dollars, and Life Expectancy in years.

Answer 1

(1) Life Expectancy = 70.1812 -0.2385*Murder+0.0382*HS Grad+0.000097*Income

Regression output					confidence interval
variables	coefficients	std. error	t (df=45)	p-value	95% lower	95% upper
Intercept	70.1812	1.1247	62.398	2.39E-45	67.9159	72.4465
Murder	-0.2385	0.0362	-6.589	4.15E-08	-0.3114	-0.1656
HS Grad	0.0382	0.0209	1.826	.0745	-0.0039	0.0804
Income	0.00009710	0.00024200	0.401	.6901	-0.00039031	0.00058451

(2) Since R^2=0.653, 65.3 percent of the variation in Life Expectancy is explained by the differences in the explanatory variables

(3)70.1812 -0.2385*11.1+0.0382*38.5+0.000097*3875
=69.38042