How do you set the y-intercept to 0 for a trendline? HELP PLEASE!!

Question

Level 1

4 points

How do you set the y-intercept to 0 for a trendline? HELP PLEASE!!

So I created my xy scatter plot and have the trendline and I need to know how to set the y-intercept as zero to get the slope to be the average solution of my equation but I don't know how to do this. Help PlEASE!

iMac, Mac OS X (10.6.2), intel based

Posted on Nov 22, 2009 10:02 PM

Reply

Answer 1

Badunit

Level 7

31,228 points

Nov 22, 2009 11:06 PM in response to jwheeler1292

If you want the slope with the Y intercept forced to zero, use the LINEST function. It has a parameter that allows you to force the Y intercept to zero. If you want this trendline to be on your chart, you will have to create a couple of X-Y pairs using the slope then plot them as another data set on your chart rather than using the built-in trendline.

Reply