Linear Regression determine the best fit equation y mx b a

Linear Regression: determine the best fit equation, y = mx + b, and the coefficient of correlation for the following data set. What is the predicted death rate for age 35?

Solution

Sol)

The regression equation is y=mx+b

where y is deaths and x is age

From the Excel

From the above analysis

we have correlation coefficient =0.8856

The fitted regression equation is y=42.411 - 0.42726 (Age)

Now when age=35

then Number of deaths y=42.411 - 0.42726 (35) =27.457 =27 (in thosands)

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.885619
R Square	0.78432
Adjusted R Square	0.712427
Standard Error	4.949869
Observations	5
ANOVA
	df	SS	MS	F
Regression	1	267.2964	267.2964	10.90952
Residual	3	73.50362	24.50121
Total	4	340.8
	Coefficients	Standard Error	t Stat	P-value
Intercept	42.4106	5.109562	8.300242	0.003664
Age	-0.42726	0.129358	-3.30296	0.045632