Resampling method: what it means and how to read it
In the report: Method — pairs — whole rows are drawn with replacement; residual — the fitted values plus residuals drawn with replacement.
How to read it
pairs is the safer default: it does not assume the model is right. residual assumes the errors are alike for all rows and gives narrower intervals when that holds.
In plain words
A teacher wanted a range for how many more marks go with one extra hour of study, and the Method column tells her how the computer drew her students again. With pairs, it drew whole students again and again, each with their own hours and marks, and the range came out 3.1 to 6.9. With residual, it kept her straight line and drew again only how far each student landed from that line, and the range came out narrower, 3.8 to 6.2. The narrow one fits only when those misses are about the same size for all students. Pairs does not need that, so it is the safer choice.
Example
The cell with Method is selected in each report; point at a label to see its note.
- — the sample data (50 rows) the examples use
- —
=STATS_BOOTSTRAP(Data!A1:T51, "y", "x1,x2", 2000, "pairs", 0.95)
Where you see it
STATS_BOOTSTRAP— Bootstrap confidence intervals for regression via resampling.
Related values
- Slope — The least-squares coefficient B of the last predictor of the step, the other predictors of the model held fixed — computed on the data as they are.
- Ridge penalty — The ridge penalty: 0 — ordinary logistic regression; above 0 the slopes are shrunk toward 0.
- −2 Log Likelihood (deviance) — How far the predicted probabilities are from the observed 0s and 1s: −2 times the log-likelihood. Lower is better.
- Akaike information criterion — −2 Log Likelihood plus a penalty of 2 for every coefficient.
- Bayesian information criterion — −2 Log Likelihood plus a penalty of ln(n) for every coefficient.
Get it in your sheet
One formula in a cell gives the whole report, Resampling method included. ALS Stats is a free add-on for Google Sheets™.
Install ALS Stats from Google Workspace Marketplace (opens in a new tab)