For the data set below Determine the leastsquares regressio

For the data set below ) Determine the least-squares regression e ()Compute the sun of the squared esiduals for the least-sqares egpessione lne 1020 304050 y 129 123 131 109 101 (a) Detemine the least-squares regres sio lne 5-1. pound to four decenal places as needed.)

Solution

Sol)

From The Excel Out put

The fitted Regression model is

y= -0.75(X) + 142.1

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.867647
R Square	0.75281
Adjusted R Square	0.670414
Standard Error	7.846443
Observations	5
ANOVA
	df	SS	MS	F	Significance F
Regression	1	562.5	562.5	9.136437	0.05664
Residual	3	184.7	61.56667
Total	4	747.2
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	142.1	8.229419	17.26732	0.000423	115.9103	168.2897	115.9103	168.2897
X	-0.75	0.248126	-3.02265	0.05664	-1.53965	0.039649	-1.53965	0.039649