Hypothesis Tests in Excel
Excel
How to Perform a Kolmogorov-Smirnov Test in Excel
The Kolmogorov-Smirnov test is used to determine whether or not or not a sample is normally distributed.
This test is widely used because many statistical...
Excel
How to Perform One Sample & Two Sample Z-Tests in Excel
A one sample z-test is used to test whether a population mean is significantly different than some hypothesized value.
A two sample z-test is used...
Excel
How to Perform a Sign Test in Excel (Step-by-Step)
A sign-test is a non-parametric test that is used to determine whether a population median is equal to some value.
The following step-by-step example shows...
Excel
How to Calculate Point Estimates in Excel (With Examples)
A point estimate represents a number that we calculate from sample data to estimate some population parameter. This serves as our best possible estimate...
Excel
How to Perform a Correlation Test in Excel (Step-by-Step)
One way to quantify the relationship between two variables is to use the Pearson correlation coefficient which is a measure of the linear association...
Excel
How to Perform a Durbin-Watson Test in Excel
One of the key assumptions in linear regression is that there is no correlation between the residuals, e.g. the residuals are independent.
One way to...
Excel
How to Perform a Wilcoxon Signed Rank Test in Excel (Step-by-Step)
The Wilcoxon Signed-Rank Test is the non-parametric version of the paired samples t-test.
It is used to test whether or not there is 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