Probability Distributions in Excel
Excel
How to Find the Z Critical Value in Excel
Whenever you conduct a hypothesis test, you will get a test statistic as a result. To determine if the results of the hypothesis test are...
Excel
How to Convert Between Z-Scores and Percentiles in Excel
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 fall below a...
Excel
How to Apply the Empirical Rule in Excel
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 one standard deviation...
Excel
How to Find a P-Value from a Z-Score in Excel
Many hypothesis tests in statistics result in a z-test statistic. Once we find this z-test statistic, we typically find the p-value associated with it....
Excel
How to Calculate Z-Scores in Excel
In statistics, a z-score tells us how many standard deviations away a value is from the mean. We use the following formula to calculate...
Excel
How to Find the T Critical Value in Excel
Whenever you conduct a t-test, you will get a test statistic as a result. To determine if the results of the t-test are statistically...
Excel
How to Use the Poisson Distribution in Excel
The Poisson distribution is one of the most commonly used distributions in statistics.
In Excel, we can use the POISSON.DIST() function to find the probability that...
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