VAR_P
function VAR_P(args: number | string | ApiRange | number[] = null): numberDescription
Calculates variance based on the entire population (ignores logical values and text in the population).
Parameters
Up to 255 numeric values for which the variance will be calculated. The first argument is required, subsequent arguments are optional.
Returns
numberTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
var result = oFunction.VAR_P(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16)
oWorksheet.GetRange("B2").SetValue(result);