You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
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?
