+ Reply to Thread
Results 1 to 2 of 2

Model to test accuracy of 10-20 different forecasting methods given historical data

  1. #1
    Registered User
    Join Date
    05-01-2009
    Location
    NY, NY
    MS-Off Ver
    Excel 2007
    Posts
    6

    Model to test accuracy of 10-20 different forecasting methods given historical data

    Hi,

    What I would like to do is given a couple years worth of historical sales data, forecast future sales for the next month or so. This would be done in Excel or Access.

    The problem is I am not sure which method to use (same week last year, rolling average, etc). Is there a module or add-in out there to test 10-20 or so commonly used forecasting methods and tell me which one is most accurate? I have a budget of about $200 for this.

    Thanks!

  2. #2
    Forum Expert
    Join Date
    01-03-2006
    Location
    Waikato, New Zealand
    MS-Off Ver
    2010 @ work & 2007 @ home
    Posts
    2,243

    Re: Model to test accuracy of 10-20 different forecasting methods given historical da

    hi,

    This is not a solution per se, but you may find what you need if you read through the below links & explore other threads/articles on the web:
    http://processtrends.com/toc_trend_a...with_Excel.htm from http://processtrends.com/

    or

    http://peltiertech.com/Excel/Charts/ChartIndex.html

    hth
    Rob
    Rob Brockett
    Kiwi in the UK
    Always learning & the best way to learn is to experience...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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