Hypothesis Tests in Excel

Many statistical tests make the assumption that the values in a dataset are normally distributed. One of the easiest ways to test…

A confidence interval is a range of values that is likely to contain a population parameter with a certain level of confidence.…

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

The Jarque-Bera test is a goodness-of-fit test that determines whether or not sample data have skewness and kurtosis that matches a normal…

Levene’s Test is used to determine whether two or more groups have equal variances. This is a widely used test in statistics because…

We often use the odds ratio and relative risk when performing an analysis on a 2-by-2 table, which takes on the following format: The odds ratio tells…

In statistics, when we’re interested in determining whether or not there is a significant difference between two groups we often perform a…

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…

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…

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…