 |
Download a pdf copy of this help file here |
|
Download a pdf copy of this help file here |
See also: Vose Sum Product window
VoseSumProduct(N,DistributionObject1,DistributionObject2,...)
Calculates the sum of N terms, in which each term is the product of some sampled random values.
N - the number of terms to add
DistributionObjecti - univariate distribution object of which the ith factor in each term is a random variable.
For example, say you want to model 20 (=N) customers, that each generate a revenue of $ModPERT(0,100,200,2), with a profit margin of Beta(8,2). This would be modeled with a Sum Product calculation as follows:
=VoseSumProduct(20,VoseModPertObject(0,100,200,2),VoseBetaObject(8,2))
Also see the Vose Sum Product window for an explanation about the window for this function.
See the topic Discounted cashflow modeling for a worked out example that uses the VoseSumProduct function to model revenue for a TV series.
