Returns the average of the absolute deviations of data points from their mean.
Name | Type | Description |
args | number | string | Array.<number> | 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. |
builder.CreateFile("xlsx"); var oWorksheet = Api.GetActiveSheet(); var oFunction = Api.GetWorksheetFunction(); oWorksheet.GetRange("A1").SetValue(oFunction.AVEDEV(78, 98, 123, 45, 70, 67, 3, 9, 289)); builder.SaveFile("xlsx", "AVEDEV.xlsx"); builder.CloseFile();