Hypothesis Tests in Excel

Many statistical tests make the assumption that the values in a dataset are normally distributed.…

A confidence interval is a range of values that is likely to contain a population…

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

The Jarque-Bera test is a goodness-of-fit test that determines whether or not sample data have…

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

Levene’s Test is used to determine whether two or more groups have equal variances. This is…

In statistics, when we’re interested in determining whether or not there is a significant difference…

The most common way to compare the means between two independent groups is to use…

A binomial test compares a sample proportion to a hypothesized proportion. For example, suppose we have a…

A Mann-Whitney U test (sometimes called the Wilcoxon rank-sum test) is used to compare the differences…