Documentations
List of functions available in the toolbox
List of functions available in the toolbox
QRS.RAND.JOHNSON
Free functionPremium function (only USD 19) Client-side functionServer-side function
Returns random numbers from the Johnson distribution.
Syntax
QRS.RAND.JOHNSON([rows], [cols], [mean], [variance], [skewness], [kurtosis])
- rowsnumberoptional
- The number of rows. Defaults to 1.
- colsnumberoptional
- The number of columns. Defaults to 1.
- meannumberoptional
- The mean of the distribution. Defaults to 0.
- variancenumberoptional
- The variance of the distribution. Defaults to 1.
- skewnessnumberoptional
- The skewness of the distribution. Defaults to 0.
- kurtosisnumberoptional
- The kurtosis of the distribution. Must be greater than the squared skewness plus 1. Defaults to 3.
Options
Remarks
- Blank cells are read as zeros and dates are read as numbers due to Excel limitations.
Examples
Get from AppSource
Get from Excel
- Click Insert > Get Add-ins
- Search for QRS Toolbox
- Click Add