Thread: how to get slope with a forced intercept of zero
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default 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


Reply With QuoteReply With Quote