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 › Multi-state Markov model
Runs a discrete-time Markov chain from a one-year transition matrix: where a life (or a bond) is likely to be each year, the expected time spent in each state, the EPV of a benefit paid while in a state, and multi-year default probabilities for a ratings matrix.
Some insurance pays out depending on which state a person is in, not just whether they are alive. Health moves both ways: people fall sick and recover. A multi-state model writes down the chance of each move in a year and lets the arithmetic work out where someone is likely to be later on, how long they will spend in each state, and what a benefit tied to a state is worth today. Credit ratings move the same way, with default as the state nobody leaves.
Pricing disability income and long-term care insurance, valuing benefits that depend on health status, projecting credit rating migration and multi-year default probabilities, and the multiple-state model chapters of IFoA CS2 and SOA ALTAM.
Let P_{ij} be the probability of moving from state i to j in a year. By the Markov property, the two-year probabilities are \sum_k P_{ik}P_{kj}, the matrix product, so t-year probabilities are P^t. Starting from distribution \pi_0, \pi_t=\pi_0P^t. The expected number of years in state j over n years is \sum_{t=1}^n(\pi_t)_j, and a benefit B paid at the end of each year spent in j has EPV \sum_t v^t(\pi_t)_jB.
\pi_{t} = \pi_0\,P^{t},\qquad \text{EPV} = \sum_{t=1}^{n} v^{t}\;{}_tp^{\,0j}\;B,\qquad v=\frac{1}{1+i}
A healthy life with a 5% chance of falling sick and 1% of dying each year; the sick recover with 40%, stay sick with 50% and die with 10%. After five years the life is healthy with probability 84.0%, sick 8.5% and dead 7.5%. Over 20 years it expects about 15.3 years healthy and 1.5 years sick. A benefit of 10,000 for each year spent sick is worth 10,249 today at 4%. That is the net single premium for the sickness cover.
| If you see this | It means | Do this |
|---|---|---|
| Rows rescaled warning | Probabilities do not sum to 1 | Check for a typing error in the matrix |
| Nobody ever leaves a state | A diagonal entry of 1 | Correct only for absorbing states |
| EPV seems small | Benefit state numbered wrongly | States are numbered from 1 in matrix order |
| Default probabilities too high | One-year matrix from a recession | Use a through-the-cycle matrix |
Life table, for the alive-dead special case. Credit risk, for PD and capital.
Life table · Life annuity · Life insurance pricing · Chain ladder reserving · Buhlmann credibility · Survival analysis · Mortality graduation · Aggregate loss model · Ruin probability · 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