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

1. ## 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. ## 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. ## Re: Prediction/Forecast - Excel

Originally Posted by oldbrewer
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.