t-Test, ANOVA & Nonparametric Tests in ExcelCompare Groups examines independent samples and makes inferences about the differences between them.

Independent samples occur when observations are made on different sets of items or subjects. If the values in one sample do not tell you anything about the values in the other sample, then the samples are independent. If the knowing the values in one sample could tell you something about the values in the other sample, then the samples are related.

Side-by-side univariate plots
Side-by-side univariate plots summarize the distribution of data stratified into groups.
Equality of means/medians hypothesis test
An equality hypothesis test formally tests if two or more population means/medians are different.
Equivalence of means hypothesis test
An equivalence hypothesis test formally tests if two population means are equivalent, that is, practically the same.
Difference between means/medians effect size
An effect size estimates the magnitude of the difference between two means/medians.
Multiple comparisons
Multiple comparisons make simultaneous inferences about a set of parameters.
Mean-Mean scatter plot
A mean-mean scatter plot shows a 2-dimensional representation of the differences between many means.
Homogeneity of variance hypothesis test
A homogeneity hypothesis test formally tests if the populations have equal variances.

Related concepts

Choosing a statistical test

One-way, two-way and multi-factor ANOVA

Non-parametric tests explained

Available in

From the Statistical Reference Guide for Analyse-it 6.24.0: https://analyse-it.com/docs/user-guide/compare-groups

t-Test, ANOVA & Nonparametric Tests in ExcelCompare Groups examines independent samples and makes inferences about the differences between them.

Statistical Reference Guide v6.24.0

Administrator's Guide

User's Guide

Tutorials