Thread: Setting intercept to zero with SLOPE/STEYX/etc
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] garbagesquirrel@gmail.com is offline
external usenet poster
  
Posts: 2
Default Setting intercept to zero with SLOPE/STEYX/etc
On Feb 21, 5:06 pm, Jerry W. Lewis wrote:

Note that in Excel 2003 the chart trendline R^2 is still incorrect when the
intercept is forced to zero.

Jerry

So the R^2 value generated for the trendline -- the one Excel displays
next to the trendline along with the equation -- is off? Is the one
that LINEST spits out any more accurate? Thanks again for the help.

Reply With QuoteReply With Quote