Formualizer Docs
ReferenceFunctionsStatistics Functions

DEVSQ

DEVSQ: Returns the sum of squared deviations from the mean.

Summary

DEVSQ is useful for variance-related calculations and diagnostics of spread.

Remarks

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

Examples

Sum of squared deviations from scalar values
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
8
Sum of squared deviations from a range
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
5

Runtime metadata

Category

Statistics

Signature

DEVSQ(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

COVARIANCE.S

COVARIANCE.S: Returns sample covariance for two paired numeric data sets.

EXPON.DIST

EXPON.DIST: Returns the exponential-distribution probability at `x` for rate `lambda`.

On this page

SummaryRemarksExamplesRelated functionsRuntime metadata