+ Reply to Thread
Results 1 to 1 of 1

Forecast vs. Trend

  1. #1
    Registered User
    Join Date
    08-05-2008
    Location
    Canada
    Posts
    15

    Forecast vs. Trend

    Problem: I need to create an accurate function that will forecast / trend stats for the remainder of the year or years to come. I have only two years of stats but still need as accurate of a forecast / trend as possible.

    This data will mainly be translated into a graph and will visually represent a forecast / trend for the remainder of the year.

    I have attached an example of some numbers which can be used to create a function.

    Questions related to the attached example:

    1) What function could forecast the rest of 2008 while taking 2007 trends into consideration as well

    2) What function could forecast 2009, while taking into consideration the 2007 to 2008 trends.

    Any help would be appreciated - I will be quick to respond to any questions,

    sjak
    Attached Files Attached Files

+ 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. How to use Forecast Function
    By bobbyplotts in forum Excel General
    Replies: 4
    Last Post: 03-25-2015, 05:28 AM
  2. Forecast? Trend? Average?
    By bertman77 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-21-2008, 02:51 AM
  3. Determining max y value of trend line
    By JoeW in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-19-2007, 12:15 PM
  4. Scatter Graph with Trendline and Trend band!
    By ssrirao in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 05-23-2007, 04:14 AM
  5. combination of actuals plus forecast graph
    By mmcknight in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-05-2007, 03:50 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