Probability Distributions in Excel
Excel
How to Use the Hypergeometric Distribution in Excel
The hypergeometric distribution describes the probability of choosing k objects with a certain feature in n draws without replacement, from a finite population of size N that contains K objects with...
Excel
How to Use the Geometric Distribution in Excel
The geometric distribution describes the probability of experiencing a certain amount of failures before experiencing the first success in a series of Bernoulli trials.
A Bernoulli trial...
Excel
How to Use the Exponential Distribution in Excel
The exponential distribution is a probability distribution that is used to model the time we must wait until a certain event occurs.
This distribution can...
Excel
How to Generate a Normal Distribution in Excel
To generate a normal distribution in Excel, you can use the following formula:
=NORMINV(RAND(), MEAN, STANDARD_DEVIATION)
You can then copy this formula down to as many...
Excel
How to Calculate Modified Z-Scores in Excel
In statistics, a modified z-score is calculated as:
Modified z-score = 0.6745(xi – x̃) / MAD
where:
xi: A single data value
x̃: The median of the dataset
MAD:...
Excel
How to Use the Triangular Distribution in Excel (With Examples)
The triangular distribution is a continuous probability distribution with a probability density function shaped like a triangle.
It is defined by three values:
The minimum value...
Excel
How to Calculate NormalCDF Probabilities in Excel
The NormalCDF function on a TI-83 or TI-84 calculator can be used to find the probability that a normally distributed random variable takes on...
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