Classical probability theory assumes an equal likelihood for all outcomes. For example, if you were to flip a coin, there's an equal change of it landing on "heads" or "tails." Microsoft Excel ...

In Excel, this can be achieved by using the STDEV function. 5. Calculate the VaR for various confidence intervals. In Excel, this can be achieved by using the NORM.INV function.