RiskLognormAlt, RiskLognormAltD

Description

RiskLognormAlt(arg1type, arg1value, arg2type,arg2value, arg3type,arg3value) specifies a lognormal distribution function with three type-value pairs. Each type can be either , , loc, or a value between 0 and 1 to specify a percentile. Note that is the mean of the distribution before applying any shift, is the standard deviation of the distribution, and loc is the minimum value of the distribution, that is, the amount (positive or negative) by which the distribution is shifted right from its base position with its minimum at x=0. Therefore, the mean of the shifted distribution is .

Examples

RiskLognormAlt(, 2, , 5, 95%, 30) returns a lognormal distribution starting with parameter 2 and standard deviation 5, then shifted so that the 95th percentile is 30.

Guidelines

and , if specified, must be positive. Arguments specified as percentiles must lead to a lognormal distribution with positive and standard deviation; otherwise the distribution returns #VALUE. However, the actual mean of the distribution can be negative if there is a negative value of loc.

With RiskLognormAltD, any entered percentile values are cumulative descending percentiles, where the percentile specifies the probability of a value greater than or equal to the entered value.