EconStatsCraft rigorous, plain-spoken econometrics
Econometrics that explains itself.
Regression, panel data, time series and the whole battery of tests. Every result is followed by a verdict you can defend.
Load a dataset to see it here.
EconStatsCraft › Chain ladder reserving
Takes a run-off triangle of claims (origin period, development period, amount paid), computes the volume-weighted development factors, projects each origin year to ultimate, and reports the reserve (IBNR) with Mack standard errors and a coefficient of variation.
The chain-ladder method projects insurance claims that have occurred but are not yet fully paid. It takes a run-off triangle of cumulative claims by origin year and development year, estimates how much claims grow from one development year to the next (the development factors), and applies those factors to each origin year to reach its ultimate claims.
For each development year, divide the sum of cumulative claims at the next development year by the sum at the current one, using only origin years observed at both. These volume-weighted factors are then multiplied together from each origin year's latest diagonal to project it to ultimate.
IBNR (incurred but not reported, here the outstanding reserve) is the projected ultimate claims minus the claims already paid on the latest diagonal, origin year by origin year. The total reserve is the sum across origin years.
That every origin year develops in the same proportions as past years, so the development pattern is stable. Changes in claims handling, inflation, mix of business or a large one-off claim break that assumption, and the projections for the most recent years, which rest on the longest chain of factors, are the least reliable.
Mack's model gives a standard error for the chain-ladder reserve without assuming a distribution for claims. It combines parameter error in the development factors with process variance, so you can quote the reserve with a margin, not just a point estimate.
Claims are reported and paid over years, so a recent accident year looks cheap purely because it is young. The chain ladder assumes every year develops in the same PROPORTIONS: if past years grew 1.59 times from development 0 to 1, this year will too. Multiply the latest diagonal out to ultimate with those ratios, subtract what has been paid, and the remainder is the reserve.
Setting the outstanding-claims reserve for a general (non-life) insurer: motor, liability, property. It is the workhorse reserving method and the benchmark every other method is compared against.
Let C_{ij} be cumulative claims for origin year i at development j. The volume-weighted development factor is \hat{f}_j=\frac{\sum_i C_{i,j+1}}{\sum_i C_{ij}}, summed over the origin years observed at BOTH j and j+1. Projected ultimate for a row last seen at development k is \hat{C}_{i,n}=C_{ik}\prod_{j=k}^{n-1}\hat{f}_j, and the reserve is \sum_i(\hat{C}_{i,n}-C_{ik}). Mack (1993) showed these factors are the weighted least squares estimates under the assumptions E[C_{i,j+1}\mid C_{ij}]=f_jC_{ij} and \mathrm{Var}(C_{i,j+1}\mid C_{ij})=\sigma_j^2C_{ij}, which is what makes the volume weighting the right choice and delivers a standard error for the reserve.
f_j = \frac{\sum_i C_{i,j+1}}{\sum_i C_{i,j}},\qquad \hat{C}_{i,J} = C_{i,\,\text{latest}}\prod_{j} f_j,\qquad R_i = \hat{C}_{i,J} - C_{i,\,\text{latest}}
A ten-by-ten paid triangle. The age-to-age factors decay as they should - 1.6021 from development 0 to 1, then 1.2166, 1.1155, 1.0558, 1.0311, 1.0127 - so most of the development happens in the first two years and the tail is thin. Total IBNR comes to 18,338. Look at where it sits rather than at the total: the 2016 origin year needs only 59 more, while 2022 needs 2,609, because the older years are nearly run off and the newest is being multiplied by almost the whole chain of factors. The Mack standard errors tell the other half of the story. In absolute terms uncertainty rises with the reserve (15 for 2016, 332 for 2022), but as a coefficient of variation it FALLS, from 25.9% to 12.7% - the old years have tiny reserves, so a small absolute error is a large relative one. Neither number alone is the risk: a 12.7% CoV on 2,609 is worth more capital than a 25.9% CoV on 59.
| If you see this | It means | Do this |
|---|---|---|
| Reserve dominated by the newest origin year | Correct: it has the furthest to develop | But check the factor chain applied to it |
| A development factor below 1 | Salvage, subrogation, or a data error | Investigate before accepting it |
| Residuals trending along the diagonal | A calendar-year effect: inflation or a process change | The core assumption is violated; adjust or use a model that allows it |
| Tail factor doing most of the work | Too few development periods observed | Fit a curve to the factors rather than stopping |
| One origin year distorting a factor | A large individual claim | Consider excluding it and reserving for it separately |
| Very immature latest year | The chain ladder is unstable here | Use Bornhuetter-Ferguson for that row |
Aggregate loss modelling, for the severity distribution behind the totals. Credibility, for blending an individual estimate with a collective one.
Life table · Life annuity · Life insurance pricing · Buhlmann credibility · Survival analysis · Mortality graduation · Aggregate loss model · Ruin probability · Multi-state Markov model · Loss severity fitting
Line chart · Area chart · Bar chart · Stacked bar · Scatter plot · Bubble chart · Histogram · Box plot · Pie chart · Heat map · Rebased to 100 · Lorenz curve and Gini
World map · Bivariate map · Flow map · India - state map · India - district map
Descriptive statistics · Summary by group · Two-way table · Classical statistical tests
Multiple regression (OLS) · Logit / Probit · Tobit (censored) · Truncated regression · Multinomial logit · Ordered logit / probit · Quantile regression · Poisson / Negative binomial
Time-varying coefficients (Kalman) · Unit root tests · Correlogram (ACF / PACF) · ARIMA / SARIMA · Rolling-origin cross-validation · Theta method · Unobserved components · STL forecasting · Forecast combination · Markov regime switching · Change frequency (resample) · ARCH / GARCH volatility · Decompose & filter · Spectral analysis · Exponential smoothing · Forecast accuracy
Yield curve (Nelson–Siegel / Svensson) · Dynamic factor model · Dynamic regression (ARIMAX) · Structural VAR · VAR · Granger causality · Cointegration · VECM · ARDL & bounds test
Panel regression · Panel cointegration tests · Heterogeneous panel: Mean Group & PMG · Gravity model of trade · Dynamic panel GMM · Panel diagnostics · Panel unit-root tests
Principal components (PCA) · Factor analysis · Cluster analysis
Conjoint analysis · MaxDiff (best–worst scaling) · TURF - reach of a product line · Price sensitivity (Van Westendorp) · Market basket analysis · Perceptual map · Scale reliability (Cronbach’s alpha) · Key driver analysis
Spatial autocorrelation · Spatial regression · Heckman selection · Instrumental variables (2SLS) · Difference-in-differences · Staggered difference-in-differences · Regression discontinuity · Matching & weighting · Oaxaca–Blinder decomposition
Black–Scholes option pricing · Bond price, duration & convexity · Merton distance to default · EMI / home loan planner · CAPM / beta estimation · Multi-factor model · Portfolio optimization · Value at Risk & Expected Shortfall · Performance & drawdown · Time value of money & NPV/IRR · Equity valuation (DDM, FCF, residual income) · Cost of capital (WACC) · Binomial option pricing · Option strategies (payoff & profit) · Forwards, futures & swaps · Credit risk & Basel capital · Extreme value theory (tail risk)
Life table · Life annuity · Life insurance pricing · Chain ladder reserving · Buhlmann credibility · Survival analysis · Mortality graduation · Aggregate loss model · Ruin probability · Multi-state Markov model · Loss severity fitting
Monte Carlo experiment · F-test, Wald & Chow · Structural breaks & stability
Regression vs machine learning · Ridge / Lasso / Elastic Net · Random forest · Gradient boosting
EconStatsCraft rigorous, plain-spoken econometrics
Regression, panel data, time series and the whole battery of tests. Every result is followed by a verdict you can defend.
Load a dataset to see it here.
Pick the example closest to your question. You get a spreadsheet with the right columns and a few rows showing the expected format - replace the numbers with your own, then paste or upload it back.
Copy the header row from the table above (or from the downloaded template), put your own rows underneath, and paste the whole thing here. It is checked against the layout before anything is imported.
Or click a row in the preview below.
For a units or notes row.
Search every source at once. World Bank indicators need countries and years; everything else loads in one click.
Loading the catalogue…
The engine stays loaded, so this is quick - and it leaves your open tab and panel layout alone.
⌘/Ctrl+Enter runs the current analysis. ⌘/Ctrl+P exports the session as a PDF. Esc closes this.
In the Notebook: Enter starts a new block and
Shift+Enter a new line inside one; Backspace at the start
joins back into the paragraph above; / on an empty line inserts anything.
⌘/Ctrl+B, I, E, H and
M apply bold, italic, code, highlight and maths.
#, ##, -, 1., > and
``` at the start of a line convert it.
Sign in to run unlimited analyses.
Scroll to pan · Esc to close