STDEV_S
function STDEV_S(args: number | string | number[] | ApiRange = null): numberDescription
Estimates standard deviation based on a sample (ignores logical values and text in the sample).
Parameters
Up to 255 numeric values for which the standard deviation will be calculated. The first argument is required, subsequent arguments are optional.
Returns
numberTry It
const oWorksheet = Api.GetActiveSheet();
var valueArr = [3, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 0, 1, 13, 14];
// Place the numbers in cells
for (var i = 0; i < valueArr.length; i++) {
oWorksheet.GetRange("A" + (i + 1)).SetValue(valueArr[i]);
}
var oFunction = Api.GetWorksheetFunction();
var ans = oFunction.STDEV_S(3, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 0, 1, 13, 14); //ignores logical values and text
oWorksheet.GetRange("C1").SetValue(ans);