RiskCumul
|
Description |
RiskCumul specifies a cumulative distribution with n points. The range of the cumulative curve is set by the minimum and maximum arguments. Each point on the cumulative curve has a value X and a probability p. Points on the cumulative curve are specified with increasing value and increasing probability. Any number of points can be specified for the curve. Note that even though the X,p pairs “define” the distribution, any value between minimum and maximum can be returned.
|
|
Examples |
RiskCumul(0,10,{1,5,9},{0.1,0.7,0.9}) returns a cumulative curve with 3 data points and a range of 0 to 10. The first point on the curve is 1 with a cumulative probability of 0.1 (10% of the distribution values are less than or equal to 1, 90% are greater). The second point on the curve is 5 with a cumulative probability 0.7 (70% of the distribution values are less than or equal to 5, 30% are greater). The third point on the curve is 9 with a cumulative probability of 0.9 (90% of the distribution values are less than or equal to 9, 10% are greater). RiskCumul(100,200,A1:C1,A2:C2) returns a cumulative distribution with 3 data points and a range of 100 to 200. Cells A1 through C1 hold the values of each data point, and cells A2 through C2 hold the cumulative probabilities. Note that curly braces are not required when cell ranges are used as entries to the function.
|
|
Guidelines |
The points on the curve must be specified in order of increasing value The cumulative probabilities p for must be between 0 and 1 and in order of increasing probability ( minimum must be less than X1 and maximum must be greater than Xn. The maximum number of X,p pairs is 2,147,483,647. |
|
Parameters |
min continuous parameter min < max max continuous parameter
{x} = {x1,x2,..., xN} array of continuous parameters
{p} = {p1, p2, ..., pN} array of continuous parameters
|
|
Domain |
|
|
Density and Cumulative Distribution Functions |
With the assumptions: The arrays are ordered from left to right The i index runs from 0 to N+1, with two extra elements:
|
|
Mean |
No Closed Form
|
|
Variance |
No Closed Form
|
|
Skewness |
No Closed Form
|
|
Kurtosis |
No Closed Form
|
|
Mode |
No Closed Form
|
|
Examples |
|
.
).
continuous
for 
for 
and 
.
