Is there a fast and easy way (like in MS Excel) to extrapolate a trendline forward or backwards (say to touch the y-axis).
Also, is there a way to send the trendline through the origin?
OS X Mavericks (10.9)
Hi sivshem,
Here is a scatter plot with a trendline (blue) and an equation. Extrapolate back to the Y axis (X=0) by calculating Y when X=0.
Y = 2*0+1 = 1
Add another Y(=5) to match the lowest real X value (=2) to allow a trendline (green).
I don't know if you can force a trendline through the origin in Numbers.
Regards,
Ian.
The charts don't have that capability like they do in Excel. For a linear fit, you can use LINEST to find the slope with a forced zero intercept and use that slope to extrapolate. If you are not forcing to a zero intercept, you can use FORECAST to extrapolate. Either way, you will need to create a "trendline" data series in your table and plot that on your chart along with your other data.
Can you extrapolate trendlines forward and backwards, or send through origin?
