The four-column Table is named Commission, and the two-column Table is named RunningTotals. Figure A You can create a simple expression to return a running total for the Amount and Commission values.

The article How to Calculate Contingency Reserves Using Expected Value Method originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days .

To calculate the probability of being accepted and also receiving a scholarship, the likelihood of acceptance is multiplied by the conditional probability of receiving a scholarship given acceptance.