Prediction/Forecast - Excel

[Macpop]

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.

 

[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.

 

[Macpop]

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.