Z Test for Difference Between Means: Formula, Example, Calculator, SPSS, R, Python and Excel Guide

What Is Z Test for Difference Between Means?

A Z Test for Difference Between Means is a hypothesis test used to compare the means of two independent groups. It is also called a z test for difference in means, z test for difference of means, z test for difference between two means, independent samples z test or two sample z test for means.

The test compares two group means, usually written as x̄1 and x̄2. The null hypothesis says that the two population means are equal. The alternative hypothesis says that the two population means are different. The observed difference between the two sample means is divided by the standard error of the difference. This produces a z statistic, which is interpreted using the standard normal distribution.

In this example, the outcome variable is G3 final grade. The grouping variable is school, with two independent categories: GP and MS. The main research question is: Is the mean G3 final grade different between GP and MS?

For background concepts, see Null and Alternative Hypothesis, P Value, Z Score, Standard Error, Standard Normal Distribution, Mean, Median and Mode and Descriptive Statistics.

When Should You Use a Z Test for Difference Between Means?

Use a z test for difference between means when you want to compare two independent means and the population standard deviations are known. The outcome should be numeric, and the two groups should be independent.

Null and Alternative Hypothesis for Z Test for Difference Between Means

The hypotheses compare the two population means. In this example, μGP is the population mean G3 final grade for GP school, and μMS is the population mean G3 final grade for MS school.

This worked example uses a two-tailed z test because the alternative hypothesis says the two means are different. If the research question were specifically whether GP is higher than MS, the alternative would be H₁: μGP > μMS. If the research question were whether GP is lower than MS, the alternative would be H₁: μGP < μMS.

Z Test for Difference Between Means Formula and Calculation

The z test for difference between means formula is:

z = (x̄1 - x̄2) / sqrt[(σ1² / n1) + (σ2² / n2)]

where:
x̄1 = mean of group 1
x̄2 = mean of group 2
σ1² / n1 = standard-error variance component for group 1
σ2² / n2 = standard-error variance component for group 2

For this worked example, GP is group 1 and MS is group 2.

Mean difference = 12.577 - 10.650
Mean difference = 1.926

Total variance contribution = 0.0213 + 0.0398
Total variance contribution = 0.0611

SE = sqrt(0.0611)
SE ≈ 0.247

z = 1.926 / 0.247
z ≈ 7.79

The 95% confidence interval for the difference between means is:

95% CI = difference ± 1.96 × SE

95% CI = 1.926 ± 1.96 × 0.247
95% CI = [1.442, 2.411]

Because the confidence interval is entirely above 0, it supports the same conclusion as the z statistic. The GP mean is higher than the MS mean. For more detail, see Confidence Interval, Margin of Error and Standard Error.

Conditions and Assumptions for Z Test for Difference Between Means

The z test for difference between two means has several important assumptions. These should be checked before reporting the result.

If the main concern is whether the group variances are equal, compare this test with Levene Test, Brown-Forsythe Test or Bartlett’s Test. For distribution checks, use Histogram Interpretation, Box Plot Interpretation, Q Q Plot Normality Check, Shapiro Wilk Test and Kolmogorov Smirnov Test.

Dataset and Variables Used

This worked example uses student performance data. The outcome variable is G3 final grade. The grouping variable is school, with two categories: GP and MS. The z test for difference between means compares the mean G3 final grade between these two school groups.

External dataset source: UCI Machine Learning Repository: Student Performance dataset.

Verified SPSS, Python and R Results Summary

The SPSS image output, Python charts and R validation charts support the same conclusion. GP has a higher mean G3 final grade than MS. The mean difference is 1.926, the confidence interval is entirely above zero, and the observed z statistic is far beyond the usual two-tailed critical values of ±1.96.

SPSS Image Output and Interpretation

The SPSS image output explains the z test for difference between means visually. These images show the G3 distribution by school, the group mean comparison, the confidence interval for the mean difference, the z statistic on the standard normal curve and subgroup context by sex and study time.

1. SPSS Image: G3 Distribution by School

This SPSS image shows the distribution of G3 final grades for the two school groups. The GP mean is 12.577, and the MS mean is 10.650. The GP mean line is to the right of the MS mean line, which indicates a higher average final grade for GP.

The chart is important because it shows the raw data context before the formal z statistic is interpreted. The two distributions overlap, which is normal in real education data, but their centers are different. The observed difference between the means is 1.926 grade points.

This image supports the test because the formal question is whether the visible difference between these group centers is large relative to the standard error. The later z curve and confidence interval confirm that the difference is statistically meaningful.

2. SPSS Image: Group Mean Comparison

This SPSS image focuses directly on the two means. GP has a mean of 12.577, while MS has a mean of 10.650. The difference is 1.926 grade points in favor of GP.

This is the central comparison in the z test for difference between means. The null hypothesis says that the two population means are equal. The observed data show that the GP sample mean is higher than the MS sample mean.

The chart gives a practical interpretation: GP students scored about 1.93 G3 grade points higher on average. The formal z test then determines whether this observed difference is too large to be explained by ordinary sampling variation.

3. SPSS Image: Confidence Interval for Difference Between Means

This SPSS image shows the confidence interval for the difference between means. The observed difference is 1.926, and the 95% confidence interval is [1.442, 2.411]. The no-difference reference line is 0.

The entire interval is above zero. This means the estimated population difference remains positive after sampling uncertainty is considered. In plain language, GP is likely higher than MS by about 1.44 to 2.41 G3 grade points.

This image strongly supports the z-test decision. If the interval had crossed zero, the evidence would be weaker. Since the interval is fully above zero, the result supports rejecting the null hypothesis of equal means.

4. SPSS Image: Z Statistic on the Standard Normal Curve

This SPSS image places the observed test statistic on the standard normal curve. The observed z statistic is approximately 7.79. For a two-tailed test at α = .05, the usual critical values are -1.96 and +1.96.

The observed value is far to the right of +1.96. This means the difference between the two means is far larger than what would normally be expected if the two population means were equal.

The curve explains why the p-value is extremely small. A z value near 7.79 is deep in the rejection region. Therefore, the test rejects H0: μGP = μMS.

5. SPSS Image: Mean G3 by Sex Within School

This SPSS image provides subgroup context by sex within school. The chart shows that GP is higher than MS for both female and male students. For female students, GP is around 13.004, while MS is around 11.034. For male students, GP is around 12.032, while MS is around 9.950.

The subgroup chart supports the overall school comparison because the GP advantage appears in both sex categories. The female difference is about 1.970 points, and the male difference is about 2.082 points.

This image is descriptive context. It does not replace the formal z test. The formal test compares the overall GP and MS means, while this chart helps explain the pattern within sex groups.

6. SPSS Image: Mean G3 by Study Time Within School

This SPSS image shows mean G3 by study-time category within each school. In study-time category 1, GP is around 11.529 and MS is around 9.968. In category 2, GP is around 12.733 and MS is around 10.758. In category 3, GP is around 13.563 and MS is around 12.308. In category 4, GP is around 13.407 and MS is around 11.875.

The chart shows that GP has a higher mean G3 score than MS in every study-time category. This strengthens the descriptive interpretation because the school difference is visible across study-time levels.

The image is not an adjusted statistical model. It does not prove that school differences remain after full adjustment for study time. It simply shows that the overall GP advantage appears consistently across the displayed study-time categories.

Python Charts and Interpretation

The Python charts validate the same z test for difference between means using a programmatic workflow. The Python image set includes the standard-error components chart, which shows how each group contributes to the standard error of the mean difference.

1. Python Chart: G3 Distribution by School

The Python distribution chart confirms the same pattern shown in the SPSS output. GP has a higher center than MS, with GP mean = 12.577 and MS mean = 10.650.

The chart shows overlap between the two school distributions, but the GP mean line is shifted to the right. This means the average G3 final grade is higher for GP.

This chart supports the z test because it shows the raw data pattern behind the mean comparison. The test then standardizes the difference using the standard error.

2. Python Chart: Group Mean Comparison

The Python group-mean chart shows GP = 12.577 and MS = 10.650. The difference is 1.926 grade points.

This image is the direct visual version of the hypothesis test numerator. The numerator of the z statistic is the observed mean difference, x̄GP − x̄MS.

The chart confirms that the two group means are not equal in the sample. The z test confirms that the difference is large relative to its standard error.

3. Python Chart: Confidence Interval for Difference Between Means

The Python confidence interval chart confirms the mean difference of 1.926 and the 95% confidence interval of [1.442, 2.411].

The entire confidence interval is above zero. This means the estimated population difference is positive, not merely a random sample fluctuation around zero.

The chart gives practical meaning: the GP mean is likely between about 1.44 and 2.41 final-grade points higher than the MS mean.

4. Python Chart: Z Statistic on the Standard Normal Curve

The Python standard normal curve chart shows the observed z statistic at approximately 7.79. This is far beyond the usual two-tailed rejection boundaries of ±1.96.

This image explains the p-value decision. Under the null hypothesis of equal means, a z value this extreme would be very unlikely. Therefore, the result is statistically significant.

The Python curve confirms the formal decision: reject the null hypothesis and conclude that GP and MS have significantly different mean G3 scores.

5. Python Chart: Standard Error Components

This Python chart explains the denominator of the z statistic. The GP standard-error component is 0.0213, and the MS standard-error component is 0.0398. These are the two variance contributions inside the standard error formula.

The MS component is larger than the GP component. This means the MS group contributes more to the uncertainty in the difference between means. The total variance contribution is approximately 0.0611, and the standard error is the square root of that value, approximately 0.247.

This chart is important because it shows that the z statistic is not based only on the raw difference of 1.926. The test compares that difference with the expected sampling uncertainty. Since the difference is large relative to SE ≈ 0.247, the z statistic becomes very large.

6. Python Chart: Mean G3 by Sex Within School

The Python sex-within-school chart gives exact subgroup means. For female students, GP has mean G3 13.004 and MS has mean G3 11.034. For male students, GP has mean G3 12.032 and MS has mean G3 9.950.

In both sex categories, GP has a higher mean than MS. This supports the descriptive interpretation that the school difference is not limited to one sex group.

The chart is still descriptive. The formal z test is the overall comparison between GP and MS means. A separate model would be needed to test sex effects or school-by-sex interaction.

7. Python Chart: Mean G3 by Study Time Within School

The Python study-time chart shows that GP has a higher mean G3 than MS in every displayed study-time category. The exact values are: category 1, GP = 11.529 and MS = 9.968; category 2, GP = 12.733 and MS = 10.758; category 3, GP = 13.563 and MS = 12.308; category 4, GP = 13.407 and MS = 11.875.

The pattern is consistent: GP remains above MS across study-time groups. This gives descriptive support for the overall school difference.

The chart does not replace an adjusted regression or ANOVA model. It is included to explain the data structure behind the overall z test.

R Validation Charts and Interpretation

The R validation charts provide another independent software view of the same result. R confirms the group distributions, mean comparison, confidence interval, z curve, standard error components and subgroup patterns.

1. R Chart: G3 Distribution by School

The R distribution chart confirms that the GP distribution has a higher center than the MS distribution. The group means are 12.577 for GP and 10.650 for MS.

The mean lines show that GP is shifted upward compared with MS. This matches the SPSS and Python images and confirms the same raw data pattern.

The R chart supports the final conclusion because the group mean difference is visible before standardization.

2. R Chart: Group Mean Comparison

The R group-mean comparison confirms GP = 12.577 and MS = 10.650. The visual gap between the groups is the mean difference tested in the z test.

The difference is 1.926 grade points. This means GP students have a higher average final grade than MS students in the sample.

Because R confirms the same mean values, it validates the consistency of the analysis across software workflows.

3. R Chart: Confidence Interval for Difference Between Means

The R confidence interval chart confirms the same interval: [1.442, 2.411]. The point estimate is 1.926.

The interval stays fully above zero. This means the population mean difference is estimated to be positive, with GP higher than MS.

The interval supports the null-hypothesis decision because a 95% interval that does not include zero corresponds to rejecting equal means at the 5% level.

4. R Chart: Z Statistic on the Standard Normal Curve

The R standard normal curve chart shows the observed z statistic around 7.79. This is far beyond the ordinary rejection cutoffs of ±1.96.

A z value this extreme means the observed difference would be highly unlikely if the two population means were truly equal.

The R chart supports the same final decision as SPSS and Python: reject the null hypothesis and conclude that GP and MS differ in mean G3 final grade.

5. R Chart: Standard Error Components

The R standard-error components chart confirms the two variance contributions used inside the standard error formula. The GP component is 0.0213, and the MS component is 0.0398.

The MS component is larger, so it contributes more uncertainty to the difference between means. The combined contribution is about 0.0611, and the square root gives a standard error of about 0.247.

This chart helps readers understand the mechanics of the test. The z statistic is large because the observed difference, 1.926, is much larger than the standard error.

6. R Chart: Mean G3 by Sex Within School

The R sex-within-school chart confirms that GP has higher mean G3 scores in both sex categories. For female students, GP is 13.004 and MS is 11.034. For male students, GP is 12.032 and MS is 9.950.

This subgroup pattern supports the descriptive conclusion that the GP advantage is visible in both female and male groups.

The formal test is still the overall z test for difference between means. The sex chart is included to explain the data pattern more clearly.

7. R Chart: Mean G3 by Study Time Within School

The R study-time chart confirms the same category pattern. Study-time category 1 has GP = 11.529 and MS = 9.968. Category 2 has GP = 12.733 and MS = 10.758. Category 3 has GP = 13.563 and MS = 12.308. Category 4 has GP = 13.407 and MS = 11.875.

GP is higher than MS across all four study-time categories. This provides descriptive support for the overall result.

The chart is not an adjusted test. It is a validation and interpretation chart that helps readers understand the school pattern across study-time levels.

Overall Interpretation of All SPSS, Python and R Images

All image sets tell the same statistical story. The distribution images show that GP is centered higher than MS. The mean comparison images show 12.577 versus 10.650. The confidence interval images show a difference of 1.926 with 95% CI [1.442, 2.411]. The standard-error component images show 0.0213 and 0.0398. The standard normal curve images show z = 7.79, far into the rejection region.

The final decision is consistent across SPSS, Python and R: reject the null hypothesis. The mean G3 final grade is significantly different between GP and MS, and GP has the higher mean.

How to Run Z Test for Difference Between Means in SPSS, Python, R and Excel

SPSS Method

SPSS can calculate the group means using descriptive statistics. The z statistic can then be computed from the group means and standard-error components.

* Z Test for Difference Between Means in SPSS.
* Compare mean G3 between GP and MS.

MEANS TABLES=G3 BY school
  /CELLS=COUNT MEAN STDDEV.

* Enter exact summary values from the output.
INPUT PROGRAM.
DATA LIST FREE /mean_GP mean_MS se_component_GP se_component_MS.
BEGIN DATA
12.577 10.650 0.0213 0.0398
END DATA.
END FILE.
END INPUT PROGRAM.

COMPUTE diff = mean_GP - mean_MS.
COMPUTE se_diff = SQRT(se_component_GP + se_component_MS).
COMPUTE z_value = diff / se_diff.
COMPUTE p_value_two_tailed = 2 * (1 - CDF.NORMAL(ABS(z_value), 0, 1)).
COMPUTE ci_95_low = diff - 1.96 * se_diff.
COMPUTE ci_95_high = diff + 1.96 * se_diff.
EXECUTE.

FORMATS diff se_diff z_value p_value_two_tailed ci_95_low ci_95_high (F12.6).
LIST.

Python Method

Python can calculate the z test for difference between means using direct formulas from the exact summary values.

import math

mean_gp = 12.577
mean_ms = 10.650

se_component_gp = 0.0213
se_component_ms = 0.0398

diff = mean_gp - mean_ms
se_diff = math.sqrt(se_component_gp + se_component_ms)
z_value = diff / se_diff

p_value_two_tailed = math.erfc(abs(z_value) / math.sqrt(2))

ci_low = diff - 1.96 * se_diff
ci_high = diff + 1.96 * se_diff

decision = "Reject H0" if abs(z_value) > 1.96 else "Fail to reject H0"

print("GP mean:", mean_gp)
print("MS mean:", mean_ms)
print("Difference:", diff)
print("SE:", se_diff)
print("z:", z_value)
print("p-value:", p_value_two_tailed)
print("95% CI:", ci_low, ci_high)
print("Decision:", decision)

R Method

R can reproduce the same result with direct formula calculation.

mean_gp <- 12.577
mean_ms <- 10.650

se_component_gp <- 0.0213
se_component_ms <- 0.0398

diff <- mean_gp - mean_ms
se_diff <- sqrt(se_component_gp + se_component_ms)
z_value <- diff / se_diff

p_value_two_tailed <- 2 * (1 - pnorm(abs(z_value)))

ci_low <- diff - 1.96 * se_diff
ci_high <- diff + 1.96 * se_diff

decision <- ifelse(abs(z_value) > 1.96, "Reject H0", "Fail to reject H0")

data.frame(
  mean_gp = mean_gp,
  mean_ms = mean_ms,
  difference = diff,
  se = se_diff,
  z_value = z_value,
  p_value = p_value_two_tailed,
  ci_low = ci_low,
  ci_high = ci_high,
  decision = decision
)

Excel Method

Excel can calculate the z test for difference between means using the exact output values.

How to Report the Z Test for Difference Between Means

A complete report should include the two groups, group means, mean difference, standard error, z statistic, p-value, confidence interval and decision.

In plain language, GP students scored about 1.93 G3 grade points higher than MS students on average. The confidence interval suggests the population difference is likely between about 1.44 and 2.41 grade points.

Common Mistakes in Z Test for Difference Between Means

1. Confusing a mean test with a proportion test

This test compares two means. If the outcome is pass/fail, use a Two Proportion Z Test.

2. Using a one-sample test for two groups

If there are two independent groups, use a difference-between-means test. A One Sample Z Test compares one sample mean with one benchmark.

3. Ignoring the standard deviation condition

A formal z test assumes known population standard deviations. If standard deviations are unknown and estimated from the sample, a t test is usually preferred.

4. Reporting p = .000

Do not report p = .000. If the p-value is very small, write p < .001.

5. Treating subgroup charts as adjusted tests

The sex and study-time charts are descriptive context. They do not replace a formal adjusted regression or ANOVA model.

6. Ignoring practical meaning

A statistically significant result should also be interpreted in original units. Here, the difference is about 1.93 grade points on a 0 to 20 G3 scale.

Related Statistical Guides

The following internal guides help explain the z test for difference between means and its interpretation: