
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 addin 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 






