ANOVA of the model: what it means and how to read it
In the report: ANOVA — Whether the model as a whole explains Y: the variance of Y split into the part the model explains (Regression) and the rest (Residual), with the F test — as the SPSS ANOVA table of a regression.
In plain words
A teacher guessed marks from hours of study and sleep. She wanted to know whether this guess does better than simply giving every pupil the class average. The ANOVA table splits the differences between pupils into two parts: the part her guess matches, and the part left over. She got 36 parts out of 100 matched and 64 left over. The test in the table said the matched part was hard to put down to chance alone. So the guess is worth using, but she also sees that most of the differences between pupils are still left over.
Example
The cell with ANOVA is selected in each report; point at a label to see its note.
- — the sample data (50 rows) the examples use
- —
=STATS_LINEAR(Data!A1:T51, "y", "x1,x2", 0) - — old syntax: regression steps, one-sample test against 15
=STATS_ANALYZE(Data!A1:T51, "linear(y|x1|x2) oneSample(x1|15)")
Where you see it
STATS_LINEAR— Multiple linear regression (OLS) with hierarchical steps separated by | and interactions a*b.STATS_ANALYZE— Runs several analyses on one range and returns one report.
Related values
- Sum of squares — The sum of squares of each part of the variance.
- Mean square — The sum of squares divided by its degrees of freedom.
- Sum of squares between groups — The spread of the group means around the grand mean, weighted by group size.
- Sum of squares within groups — The spread of values around their own group mean, summed over all groups.
- Mean square between groups — The between-group sum of squares per degree of freedom.
Get it in your sheet
One formula in a cell gives the whole report, ANOVA of the model included. ALS Stats is a free add-on for Google Sheets™.
Install ALS Stats from Google Workspace Marketplace (opens in a new tab)