Linear regression:
Question:
Find the regression line of Y on X for the data.
X Y
10 12
20 18
30 25
40 35
50 45
Solution:
The linear regression equation is,
Y=a+bX
Where:
Y = dependent (response) variable
X = independent (explanatory) variable
b = slope (regression line steepness)
a = intercept (where line intercepts axis)
ϵ = regression residual (error)
An arbitrary value was selected to carry out the regression analysis. The Excel output for the
above data is presented below;
The steps to perform this in Excel is ,
1) Enter the data in Excel
2) Click on Data analysis >>> A list will appears to you >>> From that select Regression
3) For input : select Y range
4) For output : Select X range
5) Choose output cell and click on Ok, we will get the output
Question:
Find the regression line of Y on X for the data.
X Y
10 12
20 18
30 25
40 35
50 45
Solution:
The linear regression equation is,
Y=a+bX
Where:
Y = dependent (response) variable
X = independent (explanatory) variable
b = slope (regression line steepness)
a = intercept (where line intercepts axis)
ϵ = regression residual (error)
An arbitrary value was selected to carry out the regression analysis. The Excel output for the
above data is presented below;
The steps to perform this in Excel is ,
1) Enter the data in Excel
2) Click on Data analysis >>> A list will appears to you >>> From that select Regression
3) For input : select Y range
4) For output : Select X range
5) Choose output cell and click on Ok, we will get the output
