Results 1 to 3 of 3

Forecast and trend does not yield same result

Threaded View

  1. #1
    Registered User
    Join Date
    01-28-2020
    Location
    Copenhagen, Denmark
    MS-Off Ver
    2016
    Posts
    1

    Post Forecast and trend does not yield same result

    Hi All

    Everywhere I read about the differences between the Forecast function and the Trend function it states that these would yield the same result.

    However, I have experienced now that this is not always the case.

    In the attached I have used the forecasting function to identify future values, however, the future values have a downward slope in the forecasting, whereas by using the trend function (or just adding a trend line to the forecast graph) the future values should be increasing.

    Can anyone explain me why?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Trend and Forecast Data
    By MarkoGreenio in forum Excel General
    Replies: 6
    Last Post: 07-14-2019, 03:17 PM
  2. [SOLVED] TREND and FORECAST - any difference ?
    By Saturn in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-16-2012, 04:03 PM
  3. Forecast or Trend
    By vitaver in forum Excel General
    Replies: 1
    Last Post: 11-25-2011, 12:19 PM
  4. Forecast vs. Trend
    By sjak in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-27-2008, 03:16 PM
  5. Forecast? Trend? Average?
    By bertman77 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-21-2008, 02:51 AM
  6. TREND & FORECAST Functions
    By Mike in forum Excel General
    Replies: 14
    Last Post: 08-03-2005, 05:05 PM
  7. Trend Forecast Help
    By MIVELD in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-23-2005, 06:23 AM

Tags for this Thread

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