A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work. Image ...

5. Calculate the VaR for various confidence intervals. In Excel, this can be achieved by using the NORM.INV function. This function requires the probability of an event occurring, mean ...