Estimate within the interval: what it means and how to read it
In the report: Estimate within CI — TRUE (1) when the slope of the data lies inside the interval.
How to read it
Normally TRUE. FALSE means the slope of the data lies outside the percentile interval of the resamples — a sign of bias or instability of the bootstrap, worth a second look.
In plain words
A teacher found that students who studied one hour more got 5 points more. The computer then drew her own students again and again, 2000 times, worked out the points per hour each time and made a range from the middle answers, 3.2 to 6.8. She wanted to check that her own 5 fits in that range. The column estimate within the range said TRUE: 5 lies inside. That is the usual answer. If it had said FALSE, her 5 would lie outside the range of the redraws, a sign that they lean to one side or jump around too much, and she would take a second look.
Example
The cell with Estimate within CI 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
- p-value — The probability of a result at least this extreme if there were no effect (if the null hypothesis held).
- Adjusted p of the pair — The p of the pair corrected for the number of comparisons by the posthoc method.
- Lower bound of the interval — The lower bound of the confidence interval, at the level in the label.
- Upper bound of the interval — The upper bound of the confidence interval, at the level in the label.
- p of the F change — The p of F Change: P(F(df1, df2) > F Change). Empty when F Change is.
Get it in your sheet
One formula in a cell gives the whole report, Estimate within the interval included. ALS Stats is a free add-on for Google Sheets™.
Install ALS Stats from Google Workspace Marketplace (opens in a new tab)