S
safi
what are the steps to run regression using excel?
Thanks
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Alex
Two ways...
1) Go to <Tools> <Data Anlaysis> and then select
<Regression>. Then follow the steps to input your a nd y
values and then the read out will give you a pearson r
value and a means to construct the equation of the
regression line aswell as some other interesting stats.
Ordinarily the <Data Analysis> toolpak is not added into
Excel. You need to add this in.
2) Plot your data (best in scatter graph) and then right-
click and select <Add trendline...>. Here select <Linear>
and on the other tab select <Display Equation On Chart>
and <Display R-Squared Value On Chart>. this will give
you the basics.
Alex
1) Go to <Tools> <Data Anlaysis> and then select
<Regression>. Then follow the steps to input your a nd y
values and then the read out will give you a pearson r
value and a means to construct the equation of the
regression line aswell as some other interesting stats.
Ordinarily the <Data Analysis> toolpak is not added into
Excel. You need to add this in.
2) Plot your data (best in scatter graph) and then right-
click and select <Add trendline...>. Here select <Linear>
and on the other tab select <Display Equation On Chart>
and <Display R-Squared Value On Chart>. this will give
you the basics.
Alex
A
Alex Delamain
Alternatively if you want to use the results in formulae it might b
easier to use
=slope(known y's, known x's)
and
=intercept(known y's, known x's
easier to use
=slope(known y's, known x's)
and
=intercept(known y's, known x's
J
Jerry W. Lewis
In addition to the preceding suggestions, you can use LINEST() or
LOGEST() if you mean something other than simple linear regression.
Jerry
LOGEST() if you mean something other than simple linear regression.
Jerry