how to get slope with a forced intercept of zero
 

how to get slope with a forced intercept of zero in excel

how to get slope with a forced intercept of zero
 

Try using regression from data analysis.

"Dennis" wrote:

how to get slope with a forced intercept of zero in excel

how to get slope with a forced intercept of zero
 

See Help for the LINEST worksheet function.

Jerry

"Dennis" wrote:

how to get slope with a forced intercept of zero in excel

how to get slope with a forced intercept of zero
 

And yet a third way is
=SUMPRODUCT(y-range, x-range)/SUMSQ(x-range)
or the equivalent
=SUMPRODUCT(y-range, x-range)/SUMPRODUCT(x-range, x-range)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dennis" wrote in message
...
how to get slope with a forced intercept of zero in excel