Analytics Toolkit · Section 3
Distribution semantics
Exceedance probability curves — what they represent, how to read them, and how to build them from trial data.
The trial worldview gives us a table of losses. The exceedance probability (EP) curve transforms that table into the most important visualization in reinsurance: a chart showing the probability that losses exceed any given threshold.
What an EP curve represents
Section titled “What an EP curve represents”An EP curve answers the question: “What is the probability that total trial losses exceed ?”
Why this question rather than “What is the probability of exactly ?” — because in a continuous loss distribution, the probability of any exact value is effectively zero. The useful question is always about exceedance: how likely is it that losses are at least this bad? This framing directly maps to business decisions: “What is the chance we lose more than our risk appetite?” or “How much capital do we need to survive a 1-in-100 trial?”
When each trial represents one simulated year — as is typical, and as the Helios Re dataset assumes — the EP curve answers the more specific question: “What is the probability that annual losses exceed ?”
Formally:
where is the trial loss random variable. For a trial-based simulation with equiprobable trials:
In plain English: count how many trials have total loss at or above , divide by the total number of trials .
Building an EP curve
Section titled “Building an EP curve”The algorithm is straightforward:
- Compute total loss per trial — the sum of all TELT rows where
trial_id= - Sort the trial losses in descending order
- Assign rank to each (1 = largest loss)
- The exceedance probability of the -th ranked loss is
Step 2 assumes the loss-positive sign convention — the worst trials are the largest values, so descending order puts the tail at the top. Under a loss-negative convention, the sort flips to ascending and every rank formula in this chapter is mirrored.
Reading the EP curve
Section titled “Reading the EP curve”SunCoast subject loss AEP curve (20 trials). Each point is one trial's total loss. Hover for details. The dashed line shows the mean loss across all trials.
From the chart and table above, you can read off key facts about SunCoast’s subject losses — the cedent’s losses before any contract terms are applied:
- There is a 5% chance (1 in 20 years) of a $616.2M+ loss — that is the single worst trial
- There is a 10% chance (1 in 10 years) of losses reaching or exceeding $489.1M
- There is a 50% chance of exceeding $274.6M — half the trials produce losses above this level
- The average loss across all trials is $275.6M
OEP vs. AEP
Section titled “OEP vs. AEP”There are two standard EP curves, distinguished by how they summarize occurrences within a trial. To define them, we need occurrence-level losses. Write for the total loss from the occurrence at timestamp of event in trial , summed across all geographies and lines of business.
OEP (Occurrence EP)
Section titled “OEP (Occurrence EP)”The OEP curve uses the largest single occurrence per trial. It answers: “What is the probability that the peak single-occurrence loss in a trial exceeds ?”
AEP (Aggregate EP)
Section titled “AEP (Aggregate EP)”The AEP curve uses the total loss across all occurrences. It answers: “What is the probability that total trial losses exceed ?”
The AEP is always greater than or equal to the OEP at every return period, because the total loss is always at least as large as the largest occurrence. The difference between them reflects multi-occurrence risk — the accumulation of losses from multiple occurrences in the same trial.
EP curve explorer
Section titled “EP curve explorer”SunCoast subject loss EP curves (20 trials). Move your cursor over the chart for details. The dashed AEP curve is always at or above the solid OEP curve — the gap reflects multi-occurrence risk.
The EP curve gives us the full loss distribution. The next section extracts specific numbers from that distribution — the risk metrics that drive every business decision in reinsurance.