The output
The coefficient column — this is the answer
The standard error column — how much this bounces
• More spread in x → bigger terms → smaller SE. The one nobody mentions.
• Smaller residual variance (σ̂) → smaller SE. Better model, better precision.
The t-statistic — how many standard errors from zero
The p-value — the most misunderstood number in science
It is not the probability your result happened by chance.
It is not 1 minus the probability the alternative is true.
Residual standard error — the typical miss
R² — the number everyone quotes and nobody understands
The F-statistic — is anything happening at all?
Reading the same table in Stata and Excel
| R | Stata | Meaning |
|---|---|---|
| Estimate | Coef. | the coefficient |
| Std. Error | Std. Err. | standard error |
| t value | t | t-statistic |
| Pr(>|t|) | P>|t| | p-value |
| (Intercept) | _cons | intercept |
| not shown by default | [95% Conf. Interval] | confidence interval |
The six questions to ask any regression table
Determines the units of every coefficient in the table. Get this wrong and every interpretation is wrong. Look first, always.
n = 1,000. Did the dataset have 1,000? If the paper says 2,400 firms and the table says 1,850, 550 observations vanished and the paper needs to explain why. (Logs of zero. Missing data. Listwise deletion. It’s always one of those, and it’s always systematic.)
Not significant — big. 8.7% per year of education is large: four years is roughly a 40% wage difference. Compare it to something. An effect with no benchmark is a number, not a finding.
[0.074, 0.101]. What does it rule out? Would a policy conclusion change anywhere inside that range? If yes, your result is less decisive than the stars suggest.
The big one. What confounder isn’t here? In this table: ability. It raises wages and correlates with education, so our 8.7% is biased upward. The true causal return is lower.
Randomisation? Natural experiment? Instrument? Discontinuity? If the answer is “we controlled for some stuff,” the answer is no, and the word in your write-up is associated with.
• “23.8%” — approximation misapplied to a dummy. It’s 21.2%.
• “good explanatory power” — R² = 0.32 is neither good nor bad. It’s a number about prediction in a sentence about explanation.
• Nothing about what’s missing. No mention of ability. No acknowledgement that the central estimate is biased.
• No effect size discussion. Significant, yes. Big? Compared to what?
Practice questions
Worked answers
• Reverse causality. Advertising budgets are typically set as a percentage of past sales. So sales cause advertising, mechanically, in most firms’ budgeting processes. The regression cannot distinguish the direction.
• (Also good: the omitted variable is product quality; the R² may be driven by scale — big firms both advertise more and sell more — so include firm size and watch the effect collapse.)
The short version
• Standard error = how much it bounces. Small when n is big, x is spread out, residuals are small.
• t = coefficient / SE. |t| > 2 ≈ significant. It tests β = 0, which may not be your question.
• p = P(data this extreme | null true). Not P(null true). Never write p = 0.000.
• R² = fit, not truth, not causation, not model quality. It never falls when you add junk.
• F = “is anything happening?” Its real use is joint tests.
• Get the confidence interval. It’s more honest than the stars.
• Questions 5 and 6 — what’s missing, and is it causal — are the whole game.
