I’ve been working with the FORECAST worksheet function a little lately and it’s been a struggle. First a quick look at the function
FORECAST(x,known_y's,known_x's)
The known x’s and known y’s form a trendline based on linear regression, and the function returns the y coordinate on that line for the provided x.
The worksheet function seems to handle [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2010/11/11/forecast-doesnt-like-dates/
Posted
Nov 11 2010, 06:30 AM
by
Daily Dose of Excel