 |
It
is often convenient to construct a form first and add the distribution
data later.
The General Distribution form is for this purpose.
To define the distribution click the General button.
The parameter values can be entered on the dialog, but it is
convenient to leave them at 0 and enter the parameters directly
on the worksheet. Both discrete and continuous distributions
can be entered in this manner. |
| |
|
| |
An empty form is created
on the worksheet as below. |
| |
|
| |
The columns can be
used to identify any of the named distributions listed on the
distribution dialog. In the following, Binomial, Beta and Exponential
distributions are defined. The functions in row 7 and below
automatically calculate the moments and probabilities for the
named distributions. Note that just changing the distribution
name will change the meaning of the parameters that follow. |
| |
|
| |
Distributions are recognized
by name and the parameters are identified by location. The distribution
names are not case sensitive and for most only the first
three letters are necessary. The two cases requiring more letters
are the integer uniform and triangular distributions. These are
recognized by "int" appearing in the name. The table below shows
the distributions considered by the add-in with
abbreviations. The parameters associated with each are listed. |
| |
Distribution |
Abbreviation |
Parameter 1 |
Parameter 2 |
Parameter 3 |
Parameter 4 |
Bernoulli |
ber |
p |
|
|
|
Binomial |
bin |
n |
p |
|
|
Poisson |
poi |
|
|
|
|
Geometric |
geo |
p |
|
|
|
Negative
Binomial |
neg |
r |
p |
|
|
Hypergeometric |
hyp |
n |
a |
N |
|
Integer Uniform |
uni_int |
a |
b |
|
|
Integer Triangular |
tri_int |
a |
m |
b |
|
User |
use |
data rows |
|
|
|
Indexed |
ind |
data rows |
|
|
|
Normal |
nor |
|
|
|
|
Beta |
bet |
|
|
a |
b |
Exponential |
exp |
|
|
|
|
Gamma |
gam |
r |
|
|
|
Lognormal |
log |
|
|
|
|
Weibull |
wei |
|
|
|
|
Uniform |
uni |
a |
b |
|
|
Triangular |
tri |
a |
m |
b |
|
General |
gen |
|
|
|
|
|
| |
|
