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 › MaxDiff (best–worst scaling)
Respondents pick the best and worst item from each small set, and the items come out on one scale. It discriminates where a battery of 1–5 ratings does not, because it forces a trade-off instead of letting everything be important.
Ask people to rate twelve flavours out of ten and most will give sevens and eights to everything, because rating scales invite agreement and different people use them differently. Ask instead which is BEST and which is WORST out of three, repeatedly, and there is nowhere to hide - every answer is a forced comparison, the scale-use problem disappears, and the resulting utilities are on a common ruler.
Prioritising a long list where a rating scale collapses: features to build, messages to test, benefits to lead with, flavours to launch. Also whenever respondents from different cultures or segments use rating scales differently, since a forced choice removes scale-use bias entirely.
Under random utility, respondent i assigns item j a utility u_{ij}=\beta_j+\varepsilon_{ij} with \varepsilon extreme-value. The probability that j is chosen best from set S is the multinomial logit form \exp(\beta_j)/\sum_{k\in S}\exp(\beta_k), and the probability that l is chosen worst is the same with signs reversed. The best-worst pair is modelled as the choice of the ORDERED pair maximising \beta_j-\beta_l, giving P(j\text{ best},\,l\text{ worst})=\frac{\exp(\beta_j-\beta_l)}{\sum_{(a,b)\in S,\,a\ne b}\exp(\beta_a-\beta_b)}. Only differences are identified, so one item is fixed at zero. Shares are the softmax of the fitted utilities.
P(\text{best}=i,\ \text{worst}=j\mid S)=\frac{e^{u_i}}{\sum_{k\in S}e^{u_k}}\cdot\frac{e^{-u_j}}{\sum_{k\in S\setminus\{i\}}e^{-u_k}}
500 respondents, twelve flavours, three items per task, 2,000 tasks in total with exposure balanced to 1.00x. Mango comes out top with a logit utility of 1.9591 and a preference share of 28.0%, against Strawberry at 1.6918 and 21.4%. Read the utilities as DIFFERENCES rather than levels: subtract 1.6918 from 1.9591 and exponentiate, and the odds of Mango being chosen over Strawberry in a head-to-head are about 1.3 to 1 - a clear preference, and nothing like the 28-to-21 that the shares might suggest, because shares depend on the whole set on offer while the odds ratio does not. The 0-100 score column is a rescaling of the same utilities and carries no extra information; it exists because stakeholders ask for one. Note the worst-choice counts are used as well as the best: Pistachio is picked best 146 times and worst 140, which is a polarising item rather than a mediocre one, and a best-only design would have scored it identically to something nobody feels strongly about.
| If you see this | It means | Do this |
|---|---|---|
| All utilities near zero | No differentiation, or a broken design | Check items appear a balanced number of times |
| One item never chosen best or worst | Its utility is unidentified | It needs to appear in more tasks |
| Shares not matching the score ranking | Scores and softmax shares are different scales | Not an error |
| Two similar items splitting share oddly | IIA, as in any logit | Use hierarchical Bayes |
| Aggregate utilities hiding two segments | Averaging opposite preferences | Estimate individual-level utilities and cluster them |
| Very wide confidence intervals | Too few tasks per respondent | Four to six tasks per item is the usual minimum |
TURF, which combines these items into a line. Conjoint analysis, for trade-offs among attributes rather than whole items.
Conjoint analysis · TURF - reach of a product line · Price sensitivity (Van Westendorp) · Market basket analysis · Perceptual map · Scale reliability (Cronbach’s alpha) · Key driver analysis
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