Two-sample t-test and z-test

Two sample t and z tests are parametric tests used to compare two samples, independent or paired. Run them in Excel using the XLSTAT statistical software.

Two-sample t-test and z-test: Distribution plot

Two-sample t-test and z-test in Excel

Two-sample t-test and z-test are popular parametric tests in statistics. These methods are widely used when it comes to inferential statistics and enable to test a general hypothesis called the null hypothesis.

XLSTAT provides a complete and flexible two-sample t-tests and z-tests feature that proposes several standard and advanced options that will let you gain a deep insight on your data: 

  • Run a two-sample test for independent or paired samples
  • Choose between three different alternative hypotheses
  • Choose the Monte-Carlo method or the asymptotic p-value method for the computation of the p-value
  • Use an F-test to test the equality of variances and help you choose between the t-test and the z-test
  • Display dominance diagrams to make a visual comparison of the samples


What are two-sample t-tests and z-tests?

Parametric t-tests and z-tests are used to compare the means of two samples. These two tests are used to test the null hypothesis of equality of the means of two groups (samples). The calculation method differs according to the nature of the samples. A distinction is made between independent samples or paired samples. The t and z tests are known as parametric because the assumption is made that the samples are normally distributed.

Comparison of the means of two independent samples

Take a sample S1 comprising n1 observations, of mean µ1 and variance s1². Take a second sample S2, independent of S1 comprising n2 observations, of mean µ2 and variance s2². Let D be the assumed difference between the means (D is 0 when equality is assumed).

As for the z and t tests on a sample, we use:

  1. Student's t test if the true variance of the populations from which the samples are extracted is unknown;
  2. The z test if the true variance s² of the population is known.

Student's t Test

The use of Student's t test requires a decision to be taken beforehand on whether variances of the samples are to be considered equal or not. XLSTAT gives the option of using Fisher's F test to test the null hypothesis of equality of the variances of the groups (samples) and to use the result of the test in the subsequent calculations. If we consider that the two samples have the same variance, the common variance is estimated by:

s² = [(n1-1)s1² + (n2-1)s2²] / (n1 + n2 - 2)

Where s1 is the standard deviation of the first sample (group) and s2 is the standard deviation of the second sample.

The test statistic is therefore given by:

t = (µ1 - µ2 -D) / (s √1/n1 + 1/n2)

The t statistic follows a Student distribution with n1+n2-2 degrees of freedom.

If we consider that the variances are different, the statistic is given by:

t = (µ1 - µ2 -D) / (√s1²/n1 + s2²/n2)


For the z-test, the variance s² of the population is presumed to be known. The user can enter this value or estimate it from the data (this is offered for teaching purposes only). The test statistic is given by:

z = (µ1 - µ2 -D) / (σ √1/n1 + 1/n2)

The z statistic follows a normal distribution.

Comparison of the means of two paired samples

If two samples are paired, they have to be of the same size. Where values are missing from certain observations, either the observation is removed from both samples or the missing values are estimated.

We study the mean of the calculated differences for the n observations. If d is the mean of the differences, s² the variance of the differences and D the supposed difference, the statistic of the t test is given by:

T= (d-D) ⁄ (s/√n)

The t statistic follows a Student distribution with n-1 degrees of freedom.

For the z test, the statistic is as follows where σ² is the variance

z= (d-D) ⁄ (σ/√n)

The z statistic follows a normal distribution.

Alternative hypotheses

Three types of tests are possible, depending on the null hypothesis, and therefore on the alternative hypothesis chosen:

  • two-tailed test, 
  • left-tailed test,
  • right-tailed test.

Tutorials on how to run two-sample t-tests and z-tests using the XLSTAT software

Here are a few tutorials on how to use the Two-sample t-test and z-test feature:

ternary diagramneural network diagram

analyze your data with xlstat

14-day free trial