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 › Ruin probability
The classical compound-Poisson surplus process: the premium rate from the safety loading, the adjustment coefficient R that solves the Lundberg equation, the exact probability of ultimate ruin for exponential claims, and the Lundberg upper bound e^(-Ru) as a function of the initial surplus.
An insurer starts with capital, collects premium steadily, and pays claims at random moments. Ruin is the surplus hitting zero. The remarkable result is that if premium exceeds expected claims by any positive margin, the probability of ever being ruined falls exponentially in the starting capital - so a modest buffer buys a lot of safety, and the rate at which it does is a single number, the adjustment coefficient.
Teaching the link between capital, premium loading and insolvency risk; setting a target surplus for a target ruin probability; understanding why a bigger safety loading buys a disproportionate reduction in ruin risk.
The Cramer-Lundberg surplus is U(t)=u+ct-\sum_{i=1}^{N(t)}X_i with N(t) Poisson(\lambda t) and premium c=(1+\theta)\lambda E[X] for loading \theta>0. The ADJUSTMENT COEFFICIENT R is the positive root of \lambda\big(M_X(r)-1\big)=cr, where M_X is the severity moment generating function. Lundberg\'s inequality then bounds the ultimate ruin probability, \psi(u)\le e^{-Ru}, and for exponential severities it is exact: \psi(u)=\frac{1}{1+\theta}e^{-Ru} with R=\frac{\theta}{(1+\theta)E[X]}. Note \psi(0)=1/(1+\theta), which depends only on the loading and not on the claim size distribution at all.
c = (1+\theta)\,\lambda\,E[X],\qquad \lambda + cR = \lambda\,M_X(R),\qquad \psi(u) \le e^{-Ru},\qquad \psi(u) = \frac{1}{1+\theta}e^{-Ru}\ \text{(exponential claims)}
Exponential claims with mean 1, Poisson arrivals at rate 1 and a 20% premium loading give an adjustment coefficient R = theta/((1+theta) x mean) = 0.2/1.2 = 0.16667. From zero capital the probability of ultimate ruin is 1/1.2 = 0.83333 - eighty-three percent, on a book expected to make money every year, which is the fact that surprises people. Capital collapses it geometrically: 0.54937 at u = 2.5, 0.36217 at u = 5, 0.23875 at u = 7.5, 0.15740 at u = 10. Each 2.5 units of capital multiplies the ruin probability by about 0.66, and that constant ratio IS the exponential decay e^(-Ru) that Lundberg's bound describes - the bound is printed beside the exact figure and sits above it everywhere, which is what a bound should do. Note it is ULTIMATE ruin, over infinite time: the model never says when, and a 16% chance spread over a century is a different management problem from the same number over five years.
| If you see this | It means | Do this |
|---|---|---|
| Ruin probability of 1 regardless of capital | Loading is zero or negative | Premium must exceed expected claims |
| No positive root for R | Heavy-tailed severity with no MGF | Lundberg does not apply; use a subexponential approximation |
| psi(0) not equal to 1/(1+theta) | An arithmetic error, for exponential claims | This is exact and is a good check |
| Probability barely falling with capital | R is small: thin loading or fat claims | Correct, and the useful warning |
| Simulated ruin above the Lundberg bound | A simulation error: it is an upper bound | Check the premium rate in the simulation |
| Finite-horizon result above the infinite-horizon one | Impossible | The infinite-horizon probability dominates by definition |
Aggregate loss modelling, which supplies the claim process. Monte Carlo, for finite-horizon ruin where no formula exists.
Life table · Life annuity · Life insurance pricing · Chain ladder reserving · Buhlmann credibility · Survival analysis · Mortality graduation · Aggregate loss model · 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