Decision Analysis In Litigation
(Best viewed in the latest version of Chrome, Microsoft Edge or Firefox)
By Damian Curran. This is a prototype for educational and illustrative purposes only. No guarantees on coding or output accuracy.

Please Note:

1. This sheet is pre-filled with sample entries from this hypothetical case. To refresh the entries, click here: ;

2. To update the calculations, press 'tab' or click outside of the text box. Note how the values in the right-hand columns change, including the Total Expected Value.

3. Decision trees can also be used to show how the Expected Value changes as the case progresses. To progress this hypothetical case through wins in the Preliminary Hearing and the Main Hearing, click here: ;

-

-

p

Preliminary Hearing

-

p

Main Hearing

-

p

Award

-

Your Legal Costs

-

Their Legal Costs

-

Net Gain / Loss

-

p (total)

-

Expected Value

-

-

-

-

-

-

-


High Damages->

+

+

=

[net gain / loss]

x

[p]

=

[expected return]

-

-

-

-


Win Main->


Mid Damages->

+

+

=

[net gain / loss]

x

[p]

=

[expected return]

-


Win Prelim->


-

-


Low Damages->

+

+

=

[net gain / loss]

x

[p]

=

[expected return]

Case Start->


-

-


Lose Main->

-



+

+

=

[net gain / loss]

x

[p]

=

[expected return]

-


Lose Prelim->







+

+

=

[net gain / loss]

x

[p]

=

[expected return]

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-






-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Total Expected Value:

-

[Total expected return]

ERROR: All probabilities from the same decision must add to 1.0. (Eg.: [0.8] + [0.2] = [1.0])

ERROR: All entries must be numbers! (Do not enter thousand separators ",", spaces or symbols)