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 › Key driver analysis
Which drivers really move satisfaction, NPS or intent. Regression coefficients are the wrong answer here because survey drivers are always correlated, so they split a shared contribution arbitrarily; relative weights apportion it properly and sum to R².
Which parts of the experience actually drive overall satisfaction? Regressing satisfaction on its components sounds simple and is treacherous: the components are all correlated with one another, so ordinary coefficients bounce around, sometimes turn negative, and cannot be read as importance. Relative importance methods split the explained variance among correlated predictors in a way that is stable and sums to the total.
Whenever you have a battery of attribute ratings and one overall measure, and the question is where to invest. It is the standard answer in customer experience and brand tracking work.
With correlated predictors, the R^2 of a regression cannot be attributed to individual variables by their coefficients. SHAPLEY VALUE decomposition takes the average marginal contribution of each predictor over all 2^k orderings: \phi_j=\sum_{S\subseteq N\setminus\{j\}}\frac{|S|!\,(k-|S|-1)!}{k!}\left[R^2(S\cup\{j\})-R^2(S)\right], which is the unique attribution satisfying efficiency (the shares sum to R^2), symmetry and the null-player property. Johnson\'s relative weights approximate the same thing far more cheaply by orthogonalising the predictors, regressing on the orthogonal set, and mapping the weights back - which is why it is what most software actually runs.
\varepsilon_j=\sum_{k}\Lambda_{jk}^{2}\,\beta_k^{*2},\qquad \sum_j \varepsilon_j=R^2
Six service attributes, all correlated at 0.4 to 0.7, regressed on overall satisfaction. OLS gives one negative coefficient on an attribute nobody believes is harmful - the classic multicollinearity symptom. Relative weights give six non-negative shares summing to the model R-squared of 0.58, with the top driver at 0.17 and the bottom at 0.04. The ranking is stable across bootstrap resamples where the OLS coefficient signs are not, which is the practical case for the method.
| If you see this | It means | Do this |
|---|---|---|
| A negative OLS coefficient on an obviously good attribute | Multicollinearity | The reason to use relative importance at all |
| One driver with almost all the importance | It may be a restatement of the outcome | Check for near-duplicates of the dependent variable |
| Importances summing to well under 1 | They sum to R-squared, not to 1 | Normalise if reporting shares, and say which you did |
| Rankings unstable across samples | Highly correlated drivers | Report bootstrap intervals on the importances |
| Low overall R-squared | The drivers do not explain satisfaction | Importance shares of a small R-squared mean little |
| Acting on importance alone | Ignores current performance | Use the importance-performance quadrant |
Multiple regression, whose coefficients this replaces for importance. Principal components, the other answer to correlated predictors.
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)
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