Rows 6 through 13 hold
information used in the enumeration process. During the enumeration,
all possible integer values of the four variables in the range
0 through 5 are generated. The analyst should enter the names
of the variables in row 6. The program places the values of
the variable in row 7 during the enumeration process. Rows 8
through 10 hold the minimum, maximum and interval values for
each variable. Row 12 holds a formula that uses the RV_Prob
function to compute the probability the random variables take
the values given in row 7. Cell B12 computes the joint probability
as the product of the numbers in the range B11:E11. This joint
probability assumes the random variables are independent. Cell
B13 will hold the total probability enumerated after the enumeration
process is complete.
Rows 14 through 18 hold information regarding the
functions and results of the analysis. The names of the output
variables should be placed in row 14. The maroon cells in row
15 are for the analyst to place formulas that specify the functions
to be analyzed. Rows 17 and 18 will hold the results of the
analysis.
In general white cells indicate ranges that are
controlled by the analyst. Numerical values can be simply numbers
or references to other cells that compute the entries. Yellow
cells hold formulas created by the add-in and should not be
changed. Maroon cells hold formulas that are to be entered by
the analyst and green cells hold results that will be inserted
by the add-in. It is possible to enter numbers in the green
cells, especially the *value* cells in row 7, to debug
the formulas in row 15. Any numbers entered in the green cells
will ultimately be replaced by the add-in.
The example functions shown below are implemented
using Excel formulas in row 15. For simplicity the analysis
takes place entirely on the form for this example. This is not
a restriction, however, because the input variables can be linked
to any cells on the worksheet and the output values on the form
can be simple pointers to other cells on the worksheet.
The figure below shows the form with explicit Excel functions
in row 15. We have placed nonzero values in row 7 to illustrate
the functions. Note that the formulas in row 11 automatically
compute the probability of the values in row 7, and cell B12
computes their joint probability as the product of the probabilities
in row 11. |