How to determine distribution parameters from quantiles
TLDR: Feel free to download or make a copy of this Sheets to calculate the parameters of uniform, normal, loguniform, lognormal, pareto and logistic distributions (including the mean and median), based on the values of 2 quantiles.
Scenario
Given a random variable with cumulative distribution function , and two values and respecting the quantiles and , what are the parameters of the underlying distribution? Answering this question is relevant to determine the expected value (mean) of .
As a concrete example, could represent the cost-effectiveness distribution of an intervention whose 10th and 90th percentiles are 5 and 15. For this case, the inputs would be:
and .
and .
Distribution parameters
The relationship between the values and quantiles of is described by:
For a uniform distribution with minimum and maximum :
For a normal distribution with mean and standard deviation , denoting as the quantile function of the standard normal distribution[1]:
For a pareto distribution with minimum and tail index :
For a logistic distribution with mean and scale :
.
The parameters which define the distributions could be determined solving a system of 2 equations for each of the above relationships:
For a uniform distribution:
For a normal distribution:
For a loguniform or lognormal distribution:
follows a uniform or normal distribution.
This means the parameters referring to the logarithm of could be calculated replacing and by and .
For a pareto distribution:
.
.
For a logistic distribution:
.
.
Feel free to download or make a copy of this Sheets to calculate the parameters of uniform, normal, loguniform, lognormal, pareto and logistic distributions, based on the above formulas. I have also included formulas for the mean and median for all these distributions.
- ^
The standard normal distribution has mean 0, and standard deviation 1. The quantile function is the inverse of the cumulative distribution function. The quantile function of the normal distribution could be calculated via NORMINV in Sheets, and scipy.stats.norm.ppf in Python.
- Corporate campaigns for chicken welfare are 10,000 times as effective as GiveWell’s Maximum Impact Fund? by 28 Jul 2022 8:22 UTC; 78 points) (
- Red-teaming Holden Karnofsky’s AI timelines by 25 Jun 2022 14:24 UTC; 58 points) (
- Finding bugs in GiveWell’s top charities by 23 Jan 2023 16:49 UTC; 46 points) (
- Nuclear war tail risk has been exaggerated? by 25 Feb 2024 9:14 UTC; 41 points) (
- Famine deaths due to the climatic effects of nuclear war by 14 Oct 2023 12:05 UTC; 40 points) (
- Farmed animals may have positive lives now or in a few decades? by 26 Oct 2024 9:18 UTC; 24 points) (
- Future benefits of mitigating food shocks caused by abrupt sunlight reduction scenarios by 4 Mar 2023 16:22 UTC; 20 points) (
- Moral weights for various species and distributions by 3 Jul 2022 18:19 UTC; 15 points) (
- 9 May 2024 8:45 UTC; 4 points) 's comment on Updates on the EA catastrophic risk landscape by (
- 5 Jan 2024 16:37 UTC; 4 points) 's comment on Expected value and uncertainty without full Monte Carlo simulations by (
- 15 Jun 2022 20:59 UTC; 3 points) 's comment on Differences in the Intensity of Valenced Experience across Species by (
- 15 May 2024 6:52 UTC; 3 points) 's comment on Nuclear security seems like an interesting funding gap by (
- 25 Feb 2024 19:28 UTC; 2 points) 's comment on Nuclear war tail risk has been exaggerated? by (
- 22 Jun 2023 6:56 UTC; 2 points) 's comment on Principles for AI Welfare Research by (
- 6 May 2024 18:38 UTC; 2 points) 's comment on Updates on the EA catastrophic risk landscape by (
- 2 Feb 2024 18:59 UTC; 2 points) 's comment on Famine deaths due to the climatic effects of nuclear war by (
- 6 Jun 2022 12:30 UTC; 2 points) 's comment on Quantifying Uncertainty in GiveWell’s GiveDirectly Cost-Effectiveness Analysis by (
Useful stuff! I was working on something similar months ago and ended up eyeballing things.
I think the links to the sheets are broken though, they just link to this page
Sorry, and thanks! They are working now.
The hyperlink on the word “this” (in both instances) is broken. I don’t see how to get to the calculator.
Sorry, and thanks! They are working now.
Thank you for this! I had been trying to solve this exact problem recently, and I wasn’t sure if I was doing it right. And this spreadsheet is much more convenient than the way I was doing it.
Great to know that you found it useful!