MEDIAN

The following section describes the syntax and usage of the MEDIAN function in ActivityInfo.

Description

The MEDIAN function is used to find the median value from a set of values. The function returns the "middle" value from a set a values.

Syntax

MEDIAN(val1, val2, val3, ...)

Argument Required Description
val1 Yes A numeric value.
val2 Yes Another numeric value.
val3 Yes Another numeric value.
... No Any further numeric values.

If an argument is missing, NA, or non-numeric, it will be excluded from the calculation.

Result

The median value from the set of input arguments.

  • If there are an odd number of values, the function returns the value which separates the lower and higher halves of the input set.
  • If there are an even number of values, the function returns the average of the middle two values in the input set.
By Blythwood - Own work, CC BY-SA 4.0, Link

Example

We will be using the MEDIAN function to calculate the middle row value from a set of three columns.

Arguments

We will be using three Quantity fields:

  • "Value 1" (with code "val1")
  • "Value 2" (with code "val2")
  • "Value 3" (with code "val3")

Formula

MEDIAN(val1,val2,val3)

Results