LOGNORM_DIST
function LOGNORM_DIST(
arg1: number = null,
arg2: number = null,
arg3: number = null,
arg4: boolean = null,
): numberDescription
Returns the lognormal distribution of x, where ln(x) is normally distributed with the specified parameters.
Parameters
- arg1
numberdefault: null The value at which to evaluate the function, a positive number.
- arg2
numberdefault: null The mean of ln(x).
- arg3
numberdefault: null The standard deviation of ln(x), a positive number.
- arg4
booleandefault: null A logical value (true or false) that determines the function form. If it is true, the function returns the cumulative distribution function. If it is false, the function returns the probability density function.
Returns
numberTry It
const oWorksheet = Api.GetActiveSheet();
//configure function parameters
var numbersArr = [4, 3.5, 1.2];
//set values in cells
for (var i = 0; i < numbersArr.length; i++) {
oWorksheet.GetRange("A" + (i + 1)).SetValue(numbersArr[i]);
}
//get parameters
var xValue = oWorksheet.GetRange("A1");
var mean = oWorksheet.GetRange("A2");
var standardDeviation = oWorksheet.GetRange("A3");
var cummulative = true;
//invoke LOGNORM.DIST method
var oFunction = Api.GetWorksheetFunction();
var ans = oFunction.LOGNORM_DIST(xValue, mean, standardDeviation, cummulative);
//print answer
oWorksheet.GetRange("C1").SetValue(ans);