AVEDEV
function AVEDEV(args: number | string | number[] = null): numberDescription
Returns the average of the absolute deviations of data points from their mean.
Parameters
- args
number | string | number[]default: null Up to 255 numeric values for which the average of the absolute deviations will be returned. The first argument is required, subsequent arguments are optional. Arguments can be numbers or names, arrays or references that contain numbers.
Returns
numberTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.AVEDEV(78, 98, 123, 45, 70, 67, 3, 9, 289));