how to get slope with a forced intercept of zero

[Dennis]

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

 

[bj]

Try using regression from data analysis.

 

[Jerry W. Lewis]

See Help for the LINEST worksheet function.

Jerry

 

[Bernard Liengme]

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