Statistic: what it means and how to read it
In the report: Statistic — The test statistic.
How to read it
Read the p next to it.
In plain words
A teacher ran a test and saw a column called Statistic with the number 2.4 in it. She did not know what to do with it. The statistic is the first number the test works out from the marks. Taken alone it says very little, so she reads the chance column next to it. Hers said the result was hard to put down to chance alone. In the check of whether marks follow the usual bell shape, the statistic runs from 0 to 1, and close to 1 is good. In some reports this column only holds the names of the numbers in each row.
Example
The cell with Statistic 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) - — three columns, a row each
=STATS_NORMALITY(Data!A1:T51, "x,x1,x2")
Where you see it
STATS_BOOTSTRAP— Bootstrap confidence intervals for regression via resampling.STATS_NORMALITY— Shapiro–Wilk test of normality for every selected column — the Shapiro–Wilk part of the SPSS EXAMINE table "Tests of Normality" (without its Kolmogorov–Smirnov test).
Related values
- Pearson chi-square — Pearson's chi-square: how far the observed counts are from those expected if the two variables were unrelated. No continuity correction.
- Pearson Chi-Square — The same test as the chi2 at the top of the report, in the SPSS table: value, df and the asymptotic p from the chi-square distribution. No continuity correction.
- Continuity Correction (Yates) — Pearson's chi-square with the Yates correction, for a 2 × 2 table only; the row is absent for larger tables.
- Likelihood Ratio — The likelihood-ratio chi-square (G²) of the table with the same df as Pearson's; p from the chi-square distribution.
- Fisher's Exact Test — The exact p of a 2 × 2 table, in the two Exact Sig. columns; the value, df and asymptotic columns are empty. The row is absent for larger tables.
Get it in your sheet
One formula in a cell gives the whole report, Statistic included. ALS Stats is a free add-on for Google Sheets™.
Install ALS Stats from Google Workspace Marketplace (opens in a new tab)