Mean of the group: what it means and how to read it
In the report: Mean — The mean of the values of the group.
How to read it
Compare the two means: their difference is what the test checks. In a report: M = 6.06 against M = 3.04.
In plain words
A teacher compared two groups of students and wanted to see how far apart they were. She asked for the Mean of each group. The first group got 6.06 and the second got 3.04. The gap between the two averages is about 3 points, and that gap is what the test checks. Now she can write in a report: M = 6.06 against M = 3.04. When the add-on gives a range around one average, the same number is the middle of that range, like 4.72 in the middle of 4.03 to 5.41.
Example
The cell with Mean is selected in each report; point at a label to see its note.
- — the sample data (50 rows) the examples use
- —
=STATS_INDEPENDENT(Data!A1:T51, "y,x1", "welch",0.95) - — all columns starting with q
=STATS_CI(Data!A1:T51, "/^q/", 0.95, "two-sided")
Where you see it
STATS_INDEPENDENT— Independent-samples t-test for two groups: the two selected columns are the groups.STATS_CI— Calculates the confidence interval of the mean for filtered columns (Student's t).
Related values
- Standard deviation of the group — The sample standard deviation of the group (n − 1).
- N — The number of valid values in the group of the row.
- Mean rank — The average rank of the values of the group; rank 1 is the smallest value of all groups together.
- Sum of ranks — The sum of the ranks of the values of the group.
- Negative ranks — Pairs where the second column is smaller than the first (the difference second − first is negative), as SPSS.
Get it in your sheet
One formula in a cell gives the whole report, Mean of the group included. ALS Stats is a free add-on for Google Sheets™.
Install ALS Stats from Google Workspace Marketplace (opens in a new tab)