Spreadsheet Sensitivity Analysis with Crystal Ball

[1jgove]

Essentially, based on the variables determined impactfull to the business case, we estimated best case, worst case and best guess estimates. We shot for 10%, 90%, and 50% probability estimates versus estimating values at the end of the probability tails to limit extreme figures that could skew results without helping us make a better decision.

[abarashyasir1]

wonderfull, cud u provide me the guidence that how u develped , assum and ienter those variables in crystal ball software.

[1jgove]

@abarashyasir1 The variables are custom to your financial model based upon what figures you determine may change over the course of your time horizon for building a business case.

[abarashyasir1]

@1jgove If i wnt to quanitfy certain risks by probability of their occurance and their impacts.So how would you do that on crystal balls or wud b the logic.

cud define this by makin the video of that?