Analyse-it
Analyse-it
  • Products
  • Pricing
  • Support
  • About us
Download trial Sign in
  • Tutorials
  • Compare groups means tutorial

Testing for a difference of means

Probably the most common statistical analysis is a test for a difference in the means of two groups. The Student's t-test is the most popular test.

  1. Open the file tutorials\Effect of Calcium on Blood Pressure.xlsx.
  2. Click a cell in the dataset.
  3. On the Analyse-it ribbon tab, in the Statistical Analyses group, click Compare Groups drop-down, and then click Student t.
    The analysis task pane opens.
  4. In the Y (response) variable list, select Decrease.
  5. In the X (factor) variable list, select Treatment.
  6. In the Significance level edit box, enter 5%.
  7. Click Calculate.
    The results are calculated and the analysis report opens.

You can see the p-value of the hypothesis test is not significant at the 5% level. Therefore, do not reject the null hypothesis of no difference in the treatments.

student t-test

Next topic: Testing assumptions of the t-test

  •  Tutorials
  •  Distribution tutorial
  •  Correlation / PCA tutorial
  •  Compare groups means tutorial
  •  Testing for a difference of means
  •  Testing assumptions of the t-test
  •  Trying a different statistical test
  •  Association in 2-way contingency tables tutorial
  •  Simple linear regression tutorial
  •  Bland-Altman method comparison tutorial
  •  Estimating the precision of a measurement procedure (CLSI EP05-A3)
  •  Evaluating the linearity of a measurement procedure (CLSI EP06-A)
  •  Verifying the precision of a measurement procedure against a performance claim and estimating the bias (CLSI EP15-A3)
  •  Pareto charts tutorial
  •  Process control charts tutorial
  •  Process capability tutorial



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

Get Started

  • Download free trial
  • Sign In

© 2026 Analyse-it® Software, Ltd. All rights reserved.

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.