Hypothesis Tests in Excel
Excel
How to Perform a Normality Test in Excel (Step-by-Step)
Many statistical tests make the assumption that the values in a dataset are normally distributed.
One of the easiest ways to test this assumption is...
Excel
How to Calculate Confidence Intervals in Excel
A confidence interval is a range of values that is likely to contain a population parameter with a certain level of confidence. It is...
Excel
How to Find the P-value for a Correlation Coefficient in Excel
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 two variables. It...
Excel
How to Perform a Jarque-Bera Test in Excel
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 distribution.
The test...
Excel
How to Perform Levene’s Test in Excel
Levene’s Test is used to determine whether two or more groups have equal variances. This is a widely used test in statistics because many statistical...
Excel
How to Calculate Odds Ratio and Relative Risk in Excel
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 us the ratio of...
Excel
How to Calculate Cohen’s d in Excel
In statistics, when we’re interested in determining whether or not there is a significant difference between two groups we often perform a hypothesis test,...
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