Page 1 of 1

Output from Goal Seek Minimum Return

Posted: Fri Feb 05, 2021 8:08 pm
by drbrandt1
The output lists as "-0.6% (0.0%)"

What do these 2 numbers refer to? I assume the first means the plan can sustain a negative return of 0.6% and still be successful. What does (0.0%) mean? Also, I set the Goal seek probability of success to 98%, but the outcome of the goal seek run stated 100%.

Thanks in advance.

Doug

Re: Output from Goal Seek Minimum Return

Posted: Fri Feb 05, 2021 9:49 pm
by jimr
Since the probability of success didn't end up at the target probability, that means goal-seek wasn't able to converge on a result and the output isn't valid.

It might help to set the return to custom and try some different return/std deviation numbers to see if you can get it to converge (the starting values are used as the seed for goal-seek).