Could anyone explain me in an ease language what's the difference between the TREND and FORECAST-functions ?
I end up with the same result, at least when I register only three arguments in the TREND-function.
Saturn
Could anyone explain me in an ease language what's the difference between the TREND and FORECAST-functions ?
I end up with the same result, at least when I register only three arguments in the TREND-function.
Saturn
Last edited by Saturn; 08-17-2012 at 02:30 AM.
Forecast for a single value and trend for multiple values.
If I've been of help, please hit the star
Any better explanation ?
Hi Saturn,
If you are looking for a single value, you'll get the same result. Both use linear regression and least squares to come up with a result
However, TREND is more suited to data points in a series such as a time series, and is capable of computing multiple y values for multiple new x values whereas FORECASTcomputes a single new y value for a single new x value, not necessarily in a series. Not sure if that's any clearer than Spencer's response.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks