Formualizer Docs
ReferenceFunctionsStatistics Functions

AVEDEV

AVEDEV: Returns the average of absolute deviations from the mean.

Summary

AVEDEV provides a robust spread measure that is less sensitive to outliers than squared-error metrics.

Remarks

  • Returns #NUM! when no numeric values are available.
  • Non-numeric values in referenced ranges are ignored.
  • Uses the arithmetic mean as the center point.

Examples

Average absolute deviation from scalar values
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
1.3333333333333333
Average absolute deviation from a range
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
1.5

FAQ

What center does AVEDEV use for deviations?

It computes absolute deviations around the arithmetic mean of included values.

Runtime metadata

Category

Statistics

Signature

AVEDEV(arg1…: Number (Range))

This function accepts a repeating argument pattern (min args: 1).

Arity

min 1, max variadic

Arguments

arg1

Number · Range · coercion NumberLenientText

Caps

PUREREDUCTIONNUMERIC_ONLY

Source

crates/formualizer-eval/src/builtins/stats/mod.rs

Statistics Functions

Generated reference pages for Statistics functions.

BETA.DIST

BETA.DIST: Returns the beta-distribution probability for `x`, with optional lower/upper bounds.

On this page

SummaryRemarksExamplesRelated functionsFAQWhat center does AVEDEV use for deviations?Runtime metadata