Regression slope: what it means and how to read it
In the report: regressionSlope. — The least-squares slope of this column on the column xCol, on the rows where both are numbers; empty with fewer than 2 rows or without spread of X.
How to read it
How much this column changes for one unit more of X — the slope of the straight line through the points, the same as B of a linear regression with one predictor.
In plain words
A teacher put the hours of study in one column and the marks in another for 30 students. She wanted to say how much an extra hour of study goes with. She found the link between hours and marks with regressionSlope and got 5. Now she can tell the class that students who studied one hour more got, on average, 5 points higher marks. It is the slope of the straight line drawn through all the students, the same number as B in a regression with one column. Rows where either column has no number are left out.
How it is computed
Σ (x − x̄)(y − ȳ) / Σ (x − x̄)²Where you see it
STATS_DESCRIPTIVE— Column-wise descriptive statistics with flexible metric selection and optional column filtering.
Related values
- Resampling method — pairs — whole rows are drawn with replacement; residual — the fitted values plus residuals drawn with replacement.
- 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.
Get it in your sheet
One formula in a cell gives the whole report, Regression slope included. ALS Stats is a free add-on for Google Sheets™.
Install ALS Stats from Google Workspace Marketplace (opens in a new tab)