Median

Description of formula:
Returns a median of the specified parameters. The median is the number in the middle of a set – half of elements have lower values and half have higher values than it. You can pass any number of arguments of type Number, arrays of values or cell ranges.
If there is an odd number of elements, median is equal to the element in the middle of the sorted sequence, if there is an even number – median is defined as mean of the two middle values.
Syntax:
median(values, ...)
Parameters:
values
(type: Number / array of Numbers) (multiple parameter) Elements to get median from them
Returned type:
Number
Examples:
=median(A1:A16)
=median(section1.A)
=median(1, 2, 5)
=median(B3,B4,B5)
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk