Applied case · Insurance · about 75 minutes
Pricing for rare large claims
Measure claim frequency per policy-year, recognise overdispersion, describe a heavy-tailed severity distribution, and price a premium that neither ignores nor over-reacts to one huge claim.
The brief
Sahil Mutual Insurance (a fictional insurer) is re-pricing its private motor book for next year. The pricing actuary has one policy year of data on 1,500 policies. Last year a single claim of SAR 480,000 shocked the management team; the sales director now argues that “claims are usually small — about SAR 6,884 — so the premium can come down”, while the CFO wants a large increase “because of the big claim”.
Your job, as the analyst supporting the actuary:
- check the data and put frequency on a fair basis (claims per policy-year);
- test whether a simple Poisson model describes how often policyholders claim;
- describe the size of claims honestly — including the tail;
- propose a pure premium (expected claims cost per policy-year) and explain how to treat the large claim.
The data. insurance_claims has one row per policy: region, driver age band, vehicle value, exposure (the fraction of the year insured), number of claims and total amount claimed. It is synthetic — generated with a documented frequency–severity model and one planted very large claim — and describes no real insurer or policyholder.
Stakeholders. The pricing actuary (signs off rates), the CFO (solvency and profit), sales (competitiveness), and the regulator (premiums must be fair and justified).
Dataset
Motor insurance claims
1,500 rows · one row = one motor policy (one policy year) · synthetic data
| Policy | Region | Driver age band | Vehicle value (SAR) | Exposure (years) | Claims (claims) | Total claimed (SAR) |
|---|---|---|---|---|---|---|
| POL0001 | Central | 36-50 | 168500 | 1 | 0 | 0 |
| POL0002 | Eastern | 51-65 | 27500 | 1 | 0 | 0 |
| POL0003 | Western | 26-35 | 106500 | 1 | 0 | 0 |
| POL0004 | Eastern | 26-35 | 152000 | 0.94 | 0 | 0 |
| POL0005 | Western | 26-35 | 101000 | 1 | 2 | 8429.6 |
| POL0006 | Eastern | 51-65 | 72000 | 0.98 | 0 | 0 |
Included with a Formula Quest membership
This case has 4 stages and 10 graded tasks, ending with a written report.
View Formula Quest memberships