Statistics add-in software for statistical analysis in Excel
  • 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
statistics software, statistical software for Excel
  • Products
  • Store 
  • Support
  • Blog
  • About us
  • Download trial
  •  Search
  •  Sign in
  •  Contact us
Analyse-it editions
  • Standard edition
  • Medical edition
  • Method Validation edition
  • Quality Control & Improvement edition
  • Ultimate edition

  • Blog  
  • About us
  • Contact us  
  • Privacy policy


Copyright 2026 Analyse-it Software, Ltd, Leeds, United Kingdom .
We use essential cookies to run the site, and optional analytics to improve the experience for visitors. For more information see our Privacy policy.