Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

FORECAST Doesn’t Like Dates

Daily Dose of Excel

News

  • This site is published here by kind permission of Daily Dose of Excel's owner Dick Kusleika
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
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.