Hypothesis Tests in Excel

A variance ratio test is used to test whether or not two population variances are equal. This test uses the following null…

In statistics, a hypothesis test is used to test some assumption about a population parameter. There are many different types of hypothesis…

Cohen’s Kappa is used to measure the level of agreement between two raters or judges who each classify items into mutually exclusive…

The Kolmogorov-Smirnov test is used to determine whether or not or not a sample is normally distributed. This test is widely used…

A one sample z-test is used to test whether a population mean is significantly different than some hypothesized value. A two sample…

A sign-test is a non-parametric test that is used to determine whether a population median is equal to some value. The following…

A point estimate represents a number that we calculate from sample data to estimate some population parameter. This serves as our best…

One way to quantify the relationship between two variables is to use the Pearson correlation coefficient which is a measure of the…

One of the key assumptions in linear regression is that there is no correlation between the residuals, e.g. the residuals are independent.…

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…