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 › Loss severity fitting
Fits five candidate severity distributions to a column of claim amounts by maximum likelihood, ranks them by AIC, then prices a deductible and a limit with the best fit: limited expected values, the loss elimination ratio, and payment per loss and per payment.
Insurers need to know not just how often claims arrive but how big they are. Claim sizes are positive and skewed, with many small claims and a few very large ones, and the large ones drive the cost. Fitting a distribution summarises the data and, more importantly, lets you price policy features such as a deductible or a limit that change which part of the distribution the insurer pays for.
Pricing a deductible or a limit, building the severity half of an aggregate loss model, reinsurance layer pricing, and the loss models chapters of SOA ASTAM and IFoA CS1 and CS2.
For each candidate density f(x;\theta), maximum likelihood chooses \hat\theta to maximise \sum_i\log f(x_i;\theta). AIC =2k-2\log L trades fit against the number of parameters k. With the chosen fit, the limited expected value is E[X\wedge m]=\int_0^m S(x)\,dx, where S=1-F is the survival function. With deductible d and limit u, the insurer pays \min(X,u)-\min(X,d), whose mean is E[X\wedge u]-E[X\wedge d]; dividing by S(d) gives the mean per payment.
E[X\wedge d] = \int_0^{d} S(x)\,dx,\qquad \text{payment per loss} = E[X\wedge u]-E[X\wedge d],\qquad \text{LER} = \frac{E[X\wedge d]}{E[X]}
The actuarial sample's class_loss column holds 205 claims with a mean of 534 and a coefficient of variation of 0.87, generated from gamma distributions. Gamma wins on AIC with Weibull essentially tied, and lognormal is clearly worst: these claims have a lighter tail than lognormal. With a 100 deductible and a 2,000 limit, the deductible removes E[X ∧ 100] = 95.16, a loss elimination ratio of 17.8%. The expected payment is 433.86 per loss and 487.40 per payment, since 89% of claims exceed the deductible.
| If you see this | It means | Do this |
|---|---|---|
| Two fits almost tie on AIC | The data cannot tell them apart | Look at the right tail and the purpose of the fit |
| Lognormal fits poorly | Data lighter-tailed than lognormal | Prefer gamma or Weibull |
| Fit ignores the largest claims | Body dominates the likelihood | Fit the tail separately, e.g. with EVT |
| Many amounts dropped | Zeros or negatives in the column | Severity uses positive claims only |
Aggregate loss, which combines this severity with claim frequency. Extreme value theory, for the far tail.
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
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