Probability Distributions in Excel

A sampling distribution is a probability distribution of a certain statistic based on many random samples from a single population. This tutorial…

Whenever you conduct a Chi-Square test, you will end up with a Chi-Square test statistic. You can then find the p-value that…

Often in statistics, a hypothesis test will result in a t-score test statistic. Once we find this t-score, we typically find the p-value associated…

A uniform distribution is a probability distribution in which every value between an interval from a to b is equally likely to be chosen. The probability that we…

Chebyshev’s Theorem states that for any number k greater than 1, at least 1 – 1/k2 of the data values in any shaped…

An F-test produces an F-statistic. To find the p-value associated with an F-statistic in Excel, you can use the following command: =F.DIST.RT(x,…

The central limit theorem states that the sampling distribution of a sample mean is approximately normal if the sample size is large…

Whenever you conduct a hypothesis test, you will get a test statistic as a result. To determine if the results of the hypothesis…

A z-score tells us how many standard deviations away a certain value is from the mean of a dataset. A percentile tells us what percentage of observations…

The Empirical Rule, sometimes called the 68-95-99.7 rule, states that for a given dataset with a normal distribution: 68% of data values fall within…