Hypothesis Tests in Excel
Excel
How to Perform Welch’s t-test in Excel
The most common way to compare the means between two independent groups is to use a two-sample t-test. However, this test assumes that the variances...
Excel
How to Perform a Binomial Test in Excel
A binomial test compares a sample proportion to a hypothesized proportion.
For example, suppose we have a 6-sided die. If we roll it 24 times, we would...
Excel
How to Perform a Mann-Whitney U Test in Excel
A Mann-Whitney U test (sometimes called the Wilcoxon rank-sum test) is used to compare the differences between two samples when the sample distributions are not...
Excel
How to Conduct a Paired Samples t-Test in Excel
A paired samples t-test is used to compare the means of two samples when each observation in one sample can be paired with an observation...
Excel
How to Conduct a One Sample t-Test in Excel
A one sample t-test is used to test whether or not the mean of a population is equal to some value.
This tutorial explains how...
Excel
How to Conduct a Two Sample t-Test in Excel
A two sample t-test is used to test whether or not the means of two populations are equal.
This tutorial explains how to conduct a...
Subscribe
- Never miss a story with notifications
- Gain full access to our premium content
- Browse free from up to 5 devices at once
Must read