Quick Answer: Gabriels Test Result

The worked example compares G3 final grade across four studytime groups. The sample contains 649 students. The omnibus one-way ANOVA was statistically significant, F(3, 645) = 15.876, p < .001, so post hoc pairwise comparisons were justified. Gabriels Test was then used to identify which studytime groups differed from each other.

The group means increased from the lowest studytime group to the higher studytime groups. Group 1 had the lowest mean G3 score, M = 10.84. Group 2 had M = 12.09. Group 4 had M = 13.06. Group 3 had the highest mean, M = 13.23. Gabriels Test found 4 significant pairwise comparisons out of 6 total comparisons.

What Is Gabriels Test?

Gabriels Test is a post hoc multiple comparison method used after ANOVA. It compares each pair of group means while accounting for the fact that several pairwise tests are being conducted. In SPSS, Gabriel’s test appears under post hoc options for one-way ANOVA and is often selected when groups are unequal in size but not extremely unequal.

The purpose of Gabriels Test is to answer the question that the omnibus ANOVA cannot answer by itself. ANOVA tells whether at least one group mean differs from another group mean. It does not say exactly which groups differ. Gabriel’s post hoc test fills that gap by comparing every pair of group means and marking the statistically significant differences.

Gabriels Test is related to the Studentized maximum modulus logic used in multiple comparison procedures. It is more specialized than simple pairwise t tests because it adjusts the pairwise decision for the post hoc comparison setting. It is also different from Tukey HSD, Bonferroni and Games-Howell because each method uses a different adjustment and is preferred under different data conditions.

Before using Gabriels Test, review one-way ANOVA, ANOVA assumptions, Levene test, p-values, confidence intervals, and effect size.

When to Use Gabriels Test

Use Gabriels Test when you have one categorical factor with three or more groups, a continuous dependent variable, a significant one-way ANOVA, and unequal group sizes that are not extremely different. In this example, studytime has four groups and G3 final grade is the continuous outcome.

Gabriels Test Formula and Decision Logic

Gabriels Test compares two group means using the within-group error from ANOVA and a multiple-comparison critical value. The basic pairwise mean difference is:

The standard comparison logic uses the ANOVA mean square error and a pairwise standard error. In an unequal sample-size design, the standard error depends on the two group sizes being compared:

Gabriel’s method then compares the absolute mean difference with a Gabriel-style critical difference based on the multiple-comparison critical value:

The confidence interval decision is direct. If the simultaneous confidence interval for the pairwise mean difference excludes zero, the pair is significant. If the interval includes zero, the pair is not significant.

Null and Alternative Hypotheses for Gabriels Test

Gabriels Test is interpreted pair by pair. Each comparison has its own null and alternative hypothesis. The null says the two population means are equal. The alternative says the two population means are different.

Dataset and Variables Used

The worked example uses a student performance dataset. The dependent variable is G3 final grade. The factor is studytime, coded into four weekly study-time categories. The analysis asks whether average final grade differs across studytime groups and which pairs of studytime groups are significantly different after the ANOVA.

Before interpreting Gabriels Test, review the group means, distributions, variance assumption and ANOVA table. Helpful related guides include descriptive statistics, box plot interpretation, Levene test, and ANOVA in SPSS.

SPSS Output Interpretation for Gabriels Test

The SPSS output provides the main official post hoc table for Gabriels Test. It begins with group descriptives, checks homogeneity of variances, reports the one-way ANOVA, and then lists Gabriel multiple comparisons and homogeneous subsets.

SPSS Group Descriptives

SPSS Homogeneity of Variances

SPSS One-Way ANOVA Table

SPSS Gabriel Multiple Comparisons

SPSS Homogeneous Subsets

The SPSS homogeneous subsets table places group 1 in the lower subset and places groups 2, 4 and 3 in the higher subset pattern. Group 2 appears in both subset logic because it is between the lowest and highest groups. This supports the Gabriel pairwise table: group 1 is the main low-performing group, while groups 3 and 4 are not clearly separated.

Python Chart-by-Chart Interpretation

The Python charts show the full Gabriels Test workflow visually. They start with the group distributions, then show group means, Gabriel adjusted p-values, simultaneous confidence intervals and the number of significant differences connected with each group.

Python Chart 1: Group Distribution Boxplots

The boxplot shows that the lower studytime groups include more low G3 scores, while groups 3 and 4 are centered higher. Group 1 has the lowest center and visible low outliers, which explains why several post hoc differences involve group 1.

The chart is not the final post hoc decision by itself, but it gives important context. Gabriels Test compares means, while the boxplot shows both center and spread. The visual pattern supports the ANOVA result and prepares the reader for the pairwise table.

Python Chart 2: Group Means with 95% Confidence Intervals

The group means chart shows the main pattern clearly. Group 1 has the lowest mean, group 2 is higher, and groups 4 and 3 are the highest. The mean labels are approximately 10.84, 12.09, 13.06 and 13.23.

The confidence intervals help explain the post hoc results. Group 1 is separated from the higher groups, while groups 3 and 4 are very close. That is why the Gabriel comparison between groups 3 and 4 is not significant.

Python Chart 3: Gabriel Pairwise Adjusted p-values

The p-value chart shows which comparisons fall below the α = .05 reference line. The significant comparisons are 1 vs 3, 1 vs 2, 1 vs 4, and 2 vs 3. These pairs have adjusted p-values below .05.

The non-significant comparisons are 2 vs 4 and 3 vs 4. The 3 vs 4 p-value is approximately 1.000, which shows that these two groups have almost no meaningful mean separation in this analysis.

Python Chart 4: Gabriel Mean Difference Confidence Intervals

The mean difference chart uses zero as the no-difference line. Confidence intervals that do not cross zero are significant by Gabriels Test. The intervals for 1 vs 3, 1 vs 4, 1 vs 2, and 2 vs 3 exclude zero, so those comparisons are significant.

The intervals for 2 vs 4 and 3 vs 4 cross zero. That means those mean differences are not statistically clear after the Gabriel post hoc adjustment. This chart is one of the best visual explanations of the pairwise decision.

Python Chart 5: Significant Difference Count by Group

The significant difference count chart shows which groups drive the post hoc result. Group 1 is involved in three significant differences because it differs from groups 2, 3 and 4. Group 2 is involved in two significant differences because it differs from group 1 and group 3.

Group 4 is involved in fewer significant differences because it is significantly different from group 1 only. Group 3 is high in mean G3, but it is not significantly different from group 4. This chart turns the pairwise table into a practical group-level summary.

R Chart-by-Chart Validation

The R validation charts confirm the same substantive result. The same group mean pattern appears, the same significant comparisons are identified, and the same non-significant comparisons remain non-significant.

R Chart 1: Group Means with 95% Confidence Intervals

The R group means chart validates the Python and SPSS descriptive pattern. Group 1 has the lowest mean, group 2 is higher, and groups 4 and 3 are the highest. The same ordering appears across all software outputs.

This agreement is important because it confirms that the post hoc pattern is not a software artifact. The observed mean structure is stable across SPSS, Python and R.

R Chart 2: Gabriel Pairwise Adjusted p-values

The R p-value chart confirms the same significant pairs. Comparisons involving group 1 are mostly significant, and the comparison between groups 2 and 3 is also significant. The comparisons 2 vs 4 and 3 vs 4 are not significant.

This chart is useful for reporting because it separates the significant and non-significant pairs visually. Readers can quickly see that the higher studytime groups are not all different from one another.

R Chart 3: Gabriel Mean Difference Confidence Intervals

The R confidence interval chart validates the same interpretation as the Python chart. Intervals excluding zero indicate significant differences, while intervals crossing zero indicate non-significant differences.

The strongest negative differences involve group 1 compared with higher studytime groups. The smallest difference is between groups 3 and 4, and its interval crosses zero. This supports the conclusion that groups 3 and 4 are statistically similar in this example.

R Chart 4: Significant Difference Count by Group

The R significant difference count chart confirms that group 1 is the main driver of the post hoc result. Group 1 differs from three other groups, which makes it the most clearly separated category in the analysis.

The higher groups show fewer significant differences among themselves. This supports a balanced interpretation: low studytime is associated with lower G3 performance, but the highest studytime categories are not clearly different from each other.

SPSS, R, Python and Excel Workflows for Gabriels Test

The same Gabriels Test workflow can be reproduced in SPSS, R, Python and Excel. SPSS gives the official menu-based Gabriel post hoc table. Python and R are useful for reproducible analysis and custom charts. Excel is useful for understanding the underlying pairwise mean-difference logic.

SPSS Workflow

R Workflow

Python Workflow

Excel Workflow

Excel can reproduce the core comparison logic by using the ANOVA mean square error, group means and group sample sizes. Excel does not have a built-in Gabriel post hoc menu like SPSS, so Excel is best used as a transparent manual calculation sheet.

Code Blocks for Gabriels Test

SPSS Syntax

ONEWAY G3 BY studytime
  /STATISTICS DESCRIPTIVES HOMOGENEITY
  /POSTHOC = GABRIEL ALPHA(0.05).

R Code

data <- read.csv("dataset.csv")

data$studytime <- factor(data$studytime)

model <- aov(G3 ~ studytime, data = data)
summary(model)

group_summary <- aggregate(G3 ~ studytime, data = data, function(x) {
c(n = length(x), mean = mean(x), sd = sd(x))
})

print(group_summary)

# For official Gabriel output, compare with SPSS.

# R can also be used to reproduce group means, ANOVA MSE,

# pairwise mean differences and simultaneous confidence interval charts.

Python Code

import pandas as pd
import itertools
import statsmodels.api as sm
import statsmodels.formula.api as smf

df = pd.read_csv("dataset.csv")
df["studytime"] = df["studytime"].astype("category")

model = smf.ols("G3 ~ C(studytime)", data=df).fit()
anova = sm.stats.anova_lm(model, typ=2)

mse = anova.loc["Residual", "sum_sq"] / anova.loc["Residual", "df"]
df_error = anova.loc["Residual", "df"]

summary = df.groupby("studytime")["G3"].agg(["count", "mean", "std"])

rows = []
for g1, g2 in itertools.combinations(summary.index, 2):
n1 = summary.loc[g1, "count"]
n2 = summary.loc[g2, "count"]
m1 = summary.loc[g1, "mean"]
m2 = summary.loc[g2, "mean"]
diff = m1 - m2
se = (mse * (1/n1 + 1/n2)) ** 0.5
rows.append([g1, g2, n1, n2, m1, m2, diff, se])

gabriel_table = pd.DataFrame(rows, columns=[
"group_1", "group_2", "n_1", "n_2",
"mean_1", "mean_2", "mean_difference", "standard_error"
])

print(anova)
print(summary)
print(gabriel_table)

Excel Formula Pattern

Group mean:
=AVERAGEIF(group_range, group_id, value_range)

Group sample size:
=COUNTIF(group_range, group_id)

Pairwise mean difference:
=Mean_Group_i - Mean_Group_j

Pairwise standard error:
=SQRT(MSE*(1/n_i + 1/n_j))

Confidence interval:
Lower = Mean_Difference - Critical_Value*Standard_Error
Upper = Mean_Difference + Critical_Value*Standard_Error

Decision:
If the confidence interval excludes 0, the pair is significant.
If the confidence interval includes 0, the pair is not significant.

APA Reporting Wording for Gabriels Test

A one-way ANOVA was conducted to compare G3 final grade across four studytime groups. The ANOVA was statistically significant, F(3, 645) = 15.876, p < .001, indicating that mean final grade differed across studytime groups. Levene's test based on the mean was not significant, p = .400, supporting the homogeneity of variance assumption.

Gabriel post hoc comparisons indicated that group 1 had significantly lower G3 scores than group 2, group 3 and group 4. Group 2 also had significantly lower G3 scores than group 3. The comparisons between group 2 and group 4 and between group 3 and group 4 were not statistically significant. These results suggest that the lowest studytime group had lower final grades than the higher studytime groups, while the highest studytime categories did not differ clearly from each other.

Common Mistakes in Gabriels Test

Downloads and Resources

Use the following downloadable outputs to verify the Gabriels Test result and compare the SPSS, Python and R workflows.

Related Guides

Continue with these related Salar Cafe guides to understand ANOVA, assumptions, post hoc interpretation and reporting.