Analyse-it
Analyse-it
  • Products
  • Pricing
  • Support
  • About us
Download trial Sign in
  • Statistical Reference Guide
  • Compare pairs

Testing equality of means/medians (related samples)

Test if there is a difference between the means/medians of two or more related samples.

  1. Select a cell in the dataset.
  2. On the Analyse-it ribbon tab, in the Statistical Analyses group, click Compare Pairs, and then click the hypothesis test.
    The analysis task pane opens.
  3. If the data consists of paired/repeated measurements in separate variables:
    1. In the Model drop-down menu, select Paired/Repeated.
    2. In the Y list, select the quantitative variables.
  4. If the data consist of matched pairs with a separate response variable, factor variable, and blocking variable:
    1. In the Model drop-down menu, select Matched.
    2. In the Y drop-down list, select the quantitative response variable.
    3. In the X (factor) drop-down list, select the categorical factor variable identifying the groups.
    4. In the Block drop-down list, select the blocking variable identifying the matching.
  5. If performing a 2 sample hypothesis test:
    1. In the Hypotheses drop-down list, select the null and directional alternative hypotheses.
    2. In the Hypothesized difference edit box, type the expected difference under the null hypothesis.
  6. If performing a k sample hypothesis test:
    1. In the Hypothesis drop-down list, select the null and alternative hypotheses.
  7. Optional: To compare the p-value against a predefined significance level, in the Significance level edit box, type the maximum probability of rejecting the null hypothesis when in fact it is true (typically 5% or 1%).
  8. Click Calculate.
Related concepts
Equality of means/medians hypothesis test
Related reference
Dataset layout
Tests for means/medians
Available in Analyse-it Editions
Standard edition
Method Validation edition
Quality Control & Improvement edition
Ultimate edition

  •  What is Analyse-it?
  •  What's new?
  •  Administrator's Guide
  •  User's Guide
  •  Statistical Reference Guide
  •  Distribution
  •  Compare groups
  •  Compare pairs
  •  Difference plot
  •  Creating a Tukey mean-difference plot
  •  Equality of means/medians hypothesis test
  •  Equivalence of means hypothesis test
  •  Tests for means/medians
  •  Testing equality of means/medians
  •  Testing equivalence of means
  •  Difference between means/medians effect size
  •  Estimators for the difference in means/medians
  •  Estimating the difference between means/medians
  •  Study design
  •  Contingency tables
  •  Correlation and association
  •  Principal component analysis (PCA)
  •  Factor analysis (FA)
  •  Item reliability
  •  Fit model
  •  Method comparison / Agreement
  •  Measurement systems analysis (MSA)
  •  Reference interval
  •  Diagnostic performance
  •  Survival/Reliability
  •  Control charts
  •  Process capability
  •  Pareto analysis
  •  Study Designs
  •  Bibliography



Version 6.15
Published 18-Apr-2023
Products
  • Standard Edition
  • Medical Edition
  • Quality Control & Improvement Edition
  • Method Validation Edition
  • Ultimate Edition
  • Compare Editions
  • Pricing
Support
  • Documentation
  • Tutorials
  • Download latest version
  • Release history
  • Contact support
Company
  • About us
  • Blog
  • Contact us
  • Privacy policy
Copyright 2026 Analyse-it Software, Ltd.
Statistical analysis and method validation software for Microsoft Excel.
We use essential cookies to run the site, and optional analytics to improve the experience for visitors. For more information see our Privacy policy.