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 › Price sensitivity (Van Westendorp)
The four price questions, turned into four cumulative curves whose intersections give the indifference price, the optimal price point and the range of acceptable prices. Measures perceived value - not demand.
Van Westendorp asks four questions about price - at what price is it too cheap to trust, cheap, expensive, and too expensive to consider - and plots the cumulative answers. Where the curves cross gives a range of defensible prices. It is cheap, fast and widely used, and it measures stated attitudes to a price rather than willingness to pay, which is a real limitation and not a fixable one.
Early pricing work on something new, where there is no sales history and no competitor to anchor on. It is quick, it needs no design, and it gives a range to start from.
Four cumulative curves are built from the four questions: the shares finding the product too cheap and cheap are plotted DECREASING in price, and expensive and too expensive INCREASING. Four intersections follow. The point of marginal cheapness is where "too cheap" meets "expensive"; the point of marginal expensiveness is where "cheap" meets "too expensive"; between them lies the range of acceptable prices. The OPTIMAL PRICE POINT is where "too cheap" meets "too expensive" - the price minimising the share who reject it outright in either direction - and the INDIFFERENCE PRICE is where "cheap" meets "expensive", often read as the price the median respondent considers normal.
\text{OPP}:\ F_{\text{too cheap}}(p)=1-F_{\text{too expensive}}(p),\qquad \text{IDP}:\ F_{\text{cheap}}(p)=1-F_{\text{expensive}}(p)
536 usable respondents of 600 give a point of marginal cheapness of 660.08 and a point of marginal expensiveness of 940.44, so the range of acceptable prices spans 660 to 940. The optimal price point falls at 742.88 and the indifference price at 830.62. Look at the shape of that rather than the digits: the acceptable range is 280 wide on a product priced around 750, so it is more than a third of the price itself, and the two headline numbers sit 88 apart inside it. Quoting 742.88 as "the optimal price" to two decimals implies a precision the method cannot support - these are intersections of four hand-drawn cumulative curves, and moving any one of them by a few respondents moves the crossing point by more than a currency unit. The honest output is the band, with the optimal point marked inside it.
| If you see this | It means | Do this |
|---|---|---|
| Curves not crossing | Inconsistent answers or too few respondents | Screen for monotonicity first |
| A very wide acceptable range | Little consensus, or a heterogeneous sample | Segment before pricing |
| Optimal price above the point of marginal expensiveness | Impossible ordering | A data or plotting error |
| Many non-monotonic respondents | The question was not understood | Report the screen-out rate |
| Range far from the current market price | Unfamiliarity or a hypothetical bias | Validate against actual prices |
| Being asked for a revenue forecast | The method cannot produce one | Use Gabor-Granger or conjoint |
Conjoint analysis, which prices attributes within a purchase decision. Drivers analysis, for what people value beyond price.
Conjoint analysis · MaxDiff (best–worst scaling) · TURF - reach of a product line · 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