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 › Forecast accuracy
Holds back the end of the sample, fits every standard forecasting model on the rest, and ranks them on out-of-sample error - including whether any of them actually beats a naïve random walk.
A model can always be made to fit the past better by adding parameters. The only honest test of a forecast is data the model has never seen. This module hides the end of the sample, fits everything on the rest, and asks who actually wins - including whether anyone beats simply guessing that tomorrow equals today.
Whenever you claim one model forecasts better than another. In-sample fit cannot answer that question.
Split at T-h. Estimate on 1,\dots,T-h, forecast h steps, compare with the held-out values. \mathrm{RMSE}=\sqrt{\frac{1}{h}\sum_t e_t^2} punishes large misses quadratically; \mathrm{MAE}=\frac{1}{h}\sum_t |e_t| is linear; \mathrm{MAPE}=\frac{100}{h}\sum_t |e_t/y_t| is scale-free but explodes near zero. Theil's U divides your RMSE by the naive random walk's. Diebold–Mariano tests whether the mean loss differential \bar{d}=\frac{1}{h}\sum_t (e_{0t}^2-e_{1t}^2) differs significantly from zero, using its long-run variance.
\mathrm{RMSE}=\sqrt{\frac{1}{h}\sum_{t=1}^{h}(y_t-\hat{y}_t)^{2}}\qquad U=\frac{\mathrm{RMSE}_{\text{model}}}{\mathrm{RMSE}_{\text{naive}}}
176 observations to train, 24 held out, every model forecasting the whole hold-out in one shot. The winner is the MEAN - a flat line at the training average - with RMSE 0.4182 and Theil's U of 0.8185, ahead of ARIMA(1,0,0) at 0.4315 and every differenced ARIMA behind that. The naive random walk comes last at 0.5109. Diebold-Mariano confirms the ordering rather than leaving it to eyeballing: Mean beats naive at p = 0.0172, the differenced ARIMAs beat it at p ≈ 0.001, and drift is significantly WORSE at p = 0.0023. Two lessons sit in that table. A constant can be a serious forecast - on a mean-reverting series over a 24-period horizon it is hard to beat, and any model that cannot beat it is not earning its complexity. And in-sample fit would have ranked these models in nearly the opposite order, which is the entire reason the hold-out exists.
| If you see this | It means | Do this |
|---|---|---|
| Best in-sample model is worst out-of-sample | Over-fitting | Prefer BIC; prefer simpler models |
| Nothing beats the naive forecast | Series is close to a random walk | Report that honestly - it is the finding |
| Mean error consistently one sign | Systematic bias | Add a trend or drift term |
| Accuracy collapses at longer horizons | Normal | Report accuracy by horizon, not just overall |
| You tuned the model against the hold-out | Leakage | You need a third, untouched test set |
Use this to settle any ARIMA-versus-exponential-smoothing argument instead of comparing AICs.
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
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