VoseStopSum

MR-dice-icon.png Download a pdf copy of this help file  here

See also: The Stop Sum window

VoseStopSum(Distribution,total)image1094.gif

 

 

 

MR_window_StopSum_1.jpg
The Stop Sum window

1Excel_icon.gif Example model

This function generates random values from the distribution of how many samples need to be drawn randomly from a specified distribution to meet or just exceed a specific total. The parameters are

Example

A company selling loan contracts wants to know how many contracts they wills sell next year. The company employs seven sales people and each of them works 230 days a year. The time to make a loan contract can be modelled by a VoseGamma(3,5,,VoseShift(10)) distribution. The number of contracts that will be sold in one year by one sales person is then:

=VoseStopSum(VoseGamma(3,5,,VoseShift(10)),230)

To know the total number of contracts that will be sold next year by the company, we add 7 generated values from this function together.