Q#$1-$ Scenario Analysis

Q#$2$ Historical Analysis

$\backslash$table$[[$Year$,$Implicit Probability,HPR $($decimal$),$Squared Deviation,Gross Return$=1$ HPR$,$Weatth Index$*],[1,0\mathrm{.}2,-0\mathrm{.}052,,,],[2,0\mathrm{.}2,-0\mathrm{.}03,,,],[3,0\mathrm{.}2,0\mathrm{.}15,,,],[4,0\mathrm{.}2,0\mathrm{.}1,,,],[5,0\mathrm{.}2,0\mathrm{.}19,,,]]$

$\backslash$table$[[$Arithmetic average $($or Expected HPR$),],[$Variance$,],[$Standard deviation,$],[$Std dev $($df $=4),],[$Geometric Avg Return,$]]$