Prediction/Forecast - Excel
Results 1 to 3 of 3

Thread: Prediction/Forecast - Excel
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Aug 2014
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Prediction/Forecast - Excel

    Good day any help I can attain will be awesome.

    Issue: Based on two cells I would like to know the probability that the next input will meet the desired result.

    Example

    Months Yield (The expected yield in 5months is 10%)
    5 10%

    1 3% (The current yield in 1month is 3%)

    I need a formula that will tell me the probability that based on the current month's yield, how likely that the yield of 10% will be attained at month 5.

    Thank you.

  2. #2
    Board Regular
    Join Date
    Apr 2010
    Posts
    10,984
    Post Thanks / Like
    Mentioned
    13 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Prediction/Forecast - Excel

    probabilty - how confident do you want to be in the prediction, 70%, 90%, 95% ?

    Maybe the best thing to do is to plot actual yield against the predictions made each month.

  3. #3
    New Member
    Join Date
    Aug 2014
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Prediction/Forecast - Excel

    Quote Originally Posted by oldbrewer View Post
    probabilty - how confident do you want to be in the prediction, 70%, 90%, 95% ?

    Maybe the best thing to do is to plot actual yield against the predictions made each month.
    90%...for this task i need an output and not graphs.

Some videos you may like

User Tag List

Tags for this Thread

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
  •