+ Reply to Thread
Results 1 to 2 of 2

Why forecasting is hard

  1. #1
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Why forecasting is hard

    I see a lot of questions on the forum from people who are trying to do forecasts. The problem is usually that they have insufficient data to reliably forecast as far into the future as they would like. Further, they do not have a handle on all the variables that could affect their forecast.

    Here is a great example of the forecasting challenge. If you saw this graph with data up to the red arrow, how would you forecast the next month?

    forecasting2.jpg

    This is the reality:

    forecasting.JPG

    In another example, nobody would have forecasted this dip in the stock market (S&P 500), nor the rebound.

    S&P.JPG
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Why forecasting is hard

    "Predictions are difficult, especially when they concern the future.”

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Forecasting
    By phasesmu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-11-2014, 03:36 PM
  2. Forecasting
    By Buranku in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-25-2014, 09:40 PM
  3. Forecasting
    By rs1aj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-24-2014, 02:27 PM
  4. Assistance with understanding the forecast function
    By Kolacube in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-28-2013, 05:40 PM
  5. Forecasting
    By usmanfarok in forum Excel General
    Replies: 1
    Last Post: 06-14-2012, 04:17 AM
  6. Forecasting
    By leehunter99 in forum Excel General
    Replies: 3
    Last Post: 04-05-2007, 11:09 AM
  7. Forecasting
    By JR573PUTT in forum Excel General
    Replies: 6
    Last Post: 11-10-2006, 06:35 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1