Results 1 to 6 of 6

Predictive calculations

This is a discussion on Predictive calculations within the Excel Questions forums, part of the Question Forums category; I've run into a situation I can't seem to solve, so hopefully someone on here can figure it out. I'm ...

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    58

    Default Predictive calculations

    I've run into a situation I can't seem to solve, so hopefully someone on here can figure it out.

    I'm trying to "predict" what the next value would be, using previous years data.

    I've got four colums, representing 4 years. A-D Then A2-A13, B2-B13 etc. Has the values for the months in that year.

    I.e.

    2000..2001..2002..2003..2004
    13......15.......13.....11
    15......19.......21.....5
    11......22........15....13

    Now I need for column E to have the predicted value for that year. Is there a simple way, or simple formula to do this? I tried using the FORECAST formula, but couldn't get it to work.

    So do any of you know a way to do this?

    Thanks;

    JohnK

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    65,362

    Default Re: Predictive calculations

    What FORECAST formula did you try?

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    58

    Default Re: Predictive calculations

    I just tried using =FORECAST, then following the example in the Help section of Excel, but couldn't get any further than that. I just couldn't understand how they said to use it.

    I also tried using =TREND, but that didn't not yield the results I was looking for. I've never used either of those before, so I'm totally lost.

    Thanks;

    JohnK

  4. #4
    New Member
    Join Date
    Oct 2002
    Posts
    32

    Default Re: Predictive calculations

    2000 2001 2002 2003 2004
    13 15 13 11 11
    15 19 21 5 8
    11 22 15 13 15

    Formula in e2 is as follows:

    =FORECAST(E$1,A2:D2,A$1:D$1)

  5. #5
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    65,362

    Default Re: Predictive calculations

    And with Trend...

    =TREND(A2:D2,$A$1:$D$1,$E$1)

    ******** ******************** ************************************************************************>
    Microsoft Excel - Book6___Running: xl2000 : OS = Windows Windows 2000
    (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
    =

    A
    B
    C
    D
    E
    1
    20002001200220032004
    2
    1315131111
    3
    15192158
    4
    1122151315
    Sheet1*

    [HtmlMaker 2.32] To see the formula in the cells just click on the cells hyperlink or click the Name box
    PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

  6. #6
    Board Regular
    Join Date
    Mar 2002
    Posts
    58

    Default Re: Predictive calculations

    Worked like a charm. Makes a lot more sence than the help in Excel.

    Thanks again folks;

    JohnK

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com