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 › CAPM / beta estimation
Regresses an asset’s return on the market’s to recover its beta and alpha, splits its variance into the part the market explains and the part it does not, and tracks how the beta moves over a rolling window.
Beta measures how much an asset's return moves with the market. A beta of 1 moves one for one with the market, above 1 amplifies market moves, below 1 dampens them. In CAPM, beta is the only risk that earns a premium, because diversification removes the rest.
Beta is the covariance of the asset's excess return with the market's excess return, divided by the variance of the market's excess return. Equivalently, it is the slope of a regression of the asset's excess returns on the market's, which is how this calculator estimates it.
Expected return = risk-free rate + beta × (expected market return − risk-free rate). The term in brackets is the equity risk premium, and beta scales it to the asset's exposure to market risk.
Jensen's alpha is the intercept of the CAPM regression: the average return an asset earned above what its beta predicted. A positive, statistically significant alpha suggests outperformance after adjusting for market risk; an insignificant one means the returns are explained by beta alone.
It means the asset has tended to move 1.5 per cent for every 1 per cent move in the market, in either direction. It carries more market risk than the average stock, so CAPM requires a higher expected return for holding it.
A fund's return moves for two reasons: the whole market moved, and something specific to the fund happened. Regressing the fund's excess return on the market's excess return splits those apart. The slope is beta, how much market risk the fund carries. The intercept is alpha, the part the market does not explain - which is the only part a manager can claim credit for.
Estimating a stock or fund's systematic risk, computing a cost of equity, separating skill (alpha) from market exposure (beta), or checking whether a manager's returns are just leverage on the index.
The Sharpe-Lintner CAPM says expected excess return is proportional to covariance with the market: E[R_i]-R_f=\beta_i\,(E[R_m]-R_f) with \beta_i=\mathrm{Cov}(R_i,R_m)/\mathrm{Var}(R_m). That is a statement about EXPECTATIONS and has no error term. The regression actually estimated is Jensen\'s time-series form, R_{it}-R_{ft}=\alpha_i+\beta_i(R_{mt}-R_{ft})+\varepsilon_{it}, and OLS on it returns exactly the ratio above because the slope of a simple regression IS \mathrm{Cov}(x,y)/\mathrm{Var}(x). The theory\'s prediction is the testable restriction \alpha_i=0: under CAPM there is nothing left over.
R_{i,t} - R_{f,t} = \alpha_i + \beta_i\,(R_{m,t} - R_{f,t}) + \varepsilon_{i,t}
Fifteen years of monthly returns. Beta = 1.1955 (SE 0.0407), so the fund carries about 20% more market risk than the index, and the t of 4.80 reported beside it tests β = 1 rather than β = 0 - the interesting null for a fund is "as risky as the market", not "unrelated to the market". R² = 0.8287, so the market explains 83% of month-to-month variation and the risk decomposition splits the variance 82.9% systematic against 17.1% idiosyncratic. Alpha is 0.1786% a month, annualising to 2.1438%, with a monthly standard error of 0.1970% and a t of 0.91. That is the number to be careful with: two standard errors on the annualised figure is roughly ±4.7%, so the honest statement is that alpha is somewhere between about -2.5% and +6.9% a year. Consistent with real skill, and equally consistent with none. Fifteen years of monthly data is not enough to separate them, and saying so is more useful than quoting 2.1% as though it were established.
| If you see this | It means | Do this |
|---|---|---|
| Alpha large, standard error larger | Normal. Alpha is hard to estimate | Do not report significance from a short sample |
| Beta near zero on an equity fund | Wrong market series, or levels used instead of returns | Check both series are returns over the same interval |
| R-squared below 0.3 | The benchmark does not match the mandate | Use the index the fund is actually run against |
| Beta above 2 | Leverage, or a single sector | Not an error, but say which it is |
| Residuals cluster in calm and wild periods | Volatility clustering, as always in returns | Alpha is unaffected; its standard error is not. Use HAC |
| Alpha vanishes when size and value are added | It was factor exposure, not skill | Report the factor model instead. This is the usual outcome |
Factor model, for what alpha becomes once size and value are controlled for. GARCH, for the volatility clustering in the residuals.
Black–Scholes option pricing · Bond price, duration & convexity · Merton distance to default · EMI / home loan planner · 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)
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