Question

2. Solve using Microsoft Excel: Use the following data to find the equation of the regression line.

X-Bar	2	4	5	6
Y-Bar	7	11	13	20

Answer 1

Solution:

Here, we have to find the regression line for the prediction of the dependent variable y based on the independent variable x. The regression output by using excel is given as below:

Regression Statistics
Multiple R	0.941978738
R Square	0.887323944
Adjusted R Square	0.830985915
Standard Error	2.236067977
Observations	4
ANOVA
	df	SS	MS	F	Significance F
Regression	1	78.75	78.75	15.75	0.058021262
Residual	2	10	5
Total	3	88.75
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%
Intercept	0	3.401680257	0	1	-14.63624884	14.63624884
x	3	0.755928946	3.968626967	0.058021262	-0.252499743	6.252499743

The required regression equation is given as below:

ŷ = 0 + 3*x

ŷ = 3x