Question

Given are five observations for two variables, and . xi2 15 7 22 19 yi50 48 58 11 23 d. Develop the estimated regression equation by computing the values of and using equations: (Enter negative values as negative figure) (to 2 decimals) e. Use the estimated regression equation to predict the value of y when . (to 2 decimals)

Answer 1

Given data is as below-

Xi	Yi
2	50
15	48
7	58
22	11
19	23

We need to develop a regression model to predict the value of y

So, Y = f(X)

The regression output is as follows-

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.847691176
R Square	0.71858033
Adjusted R Square	0.624773773
Standard Error	12.24348307
Observations	5
ANOVA
	df	SS	MS	F	Significance F
Regression	1	1148.291367	1148.291367	7.660235644	0.069701474
Residual	3	449.7086331	149.9028777
Total	4	1598
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	64.42086331	11.00493453	5.853816136	0.009938266	29.39825009	99.44347653	29.39825009	99.44347653
X Variable 1	-2.032374101	0.734315317	-2.767713071	0.069701474	-4.369293168	0.304544966	-4.369293168	0.304544966

The regression equation is as follows-

Y = 64.42 - 2.03*X

Let me know if you need anything else, if not please don't forget to like the answer :)