Trying to extrapolate data as shown in the example. Excel trendline coefficients are almost identical to Linest coefficients but still get crazy values.
Cheers.
Trying to extrapolate data as shown in the example. Excel trendline coefficients are almost identical to Linest coefficients but still get crazy values.
Cheers.
Extend the trendline forwards and you'll see it behaves pretty much like your formula values.
Everyone who confuses correlation and causation ends up dead.
Yes, thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks