| FINC 6366 - Project 1 - Risk Assement | | Name |
| A) |
| Loss Outcome |
| Probability of Loss Outcome |
| Expected Value of Loss |
| B) |
| Column 1 | Column 2 | Column 3 | Column 4 | Column 5 |
| Loss outcomes | Probabilities | Loss Outcome - Expected Loss | Squared Difference | Squared Difference x Probability |
| Sum |
| Variance |
| Standard Deviation |
| C) |
| Column 1 | Column 2 | Column 3 |
| Number of Claims Filed | Number of Houses | Total Number of Claims |
| Sum |
| Average Frequency |
| D) |
| Number of Claims |
| Probability |
| E) |
| Column 1 | | Column 2 | Column 3 | Column 4 |
| Lower Range of Loss | Upper Range of Loss | Midpoint of Claims Range | Number of Losses | Total Dollar Amount of Losses |
| | N/A |
| Sum |
| Average Loss Severity |
| F) |
| Midpoint of Claims Range |
| Probability |
| G) |
| Row | Loss 1 | Loss 2 | Total Loss | Probability | Total Loss x Probability |
| A |
| B |
| C |
| D |
| E |
| F |
| G |
| H |
| I |
| J |
| K |
| L |
| M |
| Sum |
| H) |
| Probability |
| Loss |
| Expected Value of Loss |
| Column 1 | Column 2 | Column 3 | Column 4 | Column 5 |
| Loss outcomes | Probabilities | Loss Outcome - Expected Loss | Squared Difference | Squared Difference x Probability |
| Sum |
| Variance |
| Standard Deviation |
| I) |
| Alderan Loss | Dagobah Loss | Total Loss | Mean Loss | Probability |
| J) |
| Expected Value of Loss |
| Column 1 | Column 2 | Column 3 | Column 4 | Column 5 |
| Loss outcomes | Probabilities | Loss Outcome - Expected Loss | Squared Difference | Squared Difference x Probability |
| Sum |
| Variance |
| Standard Deviation |
Juicetea
FINC6366Project1-RiskAssessment1.xlsx
