How does the Forecast function work

**aki096** · 08-08-2008, 07:22 PM

Hi,

How does the forecast function actually work (not the syntax)? Like how is it calculated? the reason I'm asking is because I need to implement something like the forecast function in Access and I need to know how it is calculated.

Thanks

**martindwilson** · 08-10-2008, 05:39 PM

http://exceltips.vitalnews.com/Pages..._Function.html

**shg** · 08-10-2008, 06:10 PM

It's a linear regression -- the exact algorithm is shown in Help. If you wanted reassurance, you could do it in formulas and verify:

Please Login or Register  to view this content.

**ExcelIsEasy** · 01-21-2012, 05:13 AM

Here's the short tutorial about forecast function: Forecast function

How does the Forecast function work

LinkBack

Thread Tools

Rate This Thread

Display

How does the Forecast function work

Re: How does the Forecast function work

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions