|
|
|
|
|
|
Option 1. Normal Uniform Distribution
(often applies to data like blood pressure, weight, etc) |
|
|
|
|
|
|
|
|
probabilistic
|
deterministic
mean |
standard error |
|
|
|
|
|
|
|
|
|
|
|
|
| |
Description: Enter mean and standard error to generate probabilistic values.
Excel function = NORMINV().
|
|
| |
Calculated Normal Distribution Sample Values
|
| |
|
|
|
|
|
Option 2. Beta Distribution
(often applies to binomial data, like success vs failure) |
|
|
|
Success
|
Fail
|
|
|
|
probabilistic
|
deterministic
mean |
standard error |
alpha
|
beta
|
|
|
|
|
|
|
|
|
|
| |
Description: Enter number of successes and failures to generate mean, std error and probabilistic values.
Excel function = BETAINV().
|
| |
Calculated Beta Probability Sample Values
|
| |
|
|
|
|
|
| |
|
|
|
|
Option 3. Gamma
Distribution
(often applies to cost data) |
|
|
|
|
probabilistic
|
deterministic
mean
|
standard error |
alpha
|
beta
|
|
|
|
|
|
|
|
|
|
|
Description: Enter mean and standard error to generate alpha, beta and probablistic values.
Excel function = GAMMAINV().
|
|
|
alpha = (mean * mean)/(std error*std error)___________ variance = s*s |
|
|
beta = (variance)/mean |
| |
|
|
|
|
|
| |
Calculated Gamma Distribution Sample Values
|
| |
