Tabular IQ
Back to Function Index

AVG()

Overview

AVG() calculates the arithmetic mean (average) of the numbers in the specified list. The function sums all the numbers and divides by the count of numbers. This is useful for finding the central tendency of a set of values.

Function Format 

AVG(number1 [, number2, number3, ...])

Return Value 

AVG() returns a numeric value representing the arithmetic mean of the input numbers

Examples 


AVG(3, 1, 2)         = 2      (sum: 6, count: 3)
AVG(3, 1, 4, 2)      = 2.5    (sum: 10, count: 4)
AVG(-3, 1, -4, 2)    = -1     (sum: -4, count: 4)
AVG(10, 20, 30)      = 20     (sum: 60, count: 3)
AVG(1.5, 2.5, 3.5)   = 2.5    (sum: 7.5, count: 3)

Notes

  • The function accepts any number of numeric arguments.
  • All arguments must be numeric values.
  • NULL values are ignored in the calculation.
  • The result will be NULL if all arguments are NULL.
  • The function can handle both positive and negative numbers.
  • The result can be a decimal number even if all inputs are integers.
  • This function is commonly used in statistical analysis and reporting.

See Also