VAR_S
function VAR_S(args: number | string | ApiRange | number[] = null): numberDescription
Estimates variance based on a sample (ignores logical values and text in the sample).
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_S(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16)
oWorksheet.GetRange("B2").SetValue(result);