Vanguard Software
Forecasting & Planning Solutions
Home Products Solutions Services Customers Partners Company
 
Applying science to business management

contents.gifindex.gifprev1.gifnext1.gif

med

Format: med( list )
med(
x1, x2, ... )

Arguments: [any] list Input list

(any) x1, x2, ... Input values

Returns: (any) The median of all elements in list if only one argument is supplied or the median of all arguments if more than one argument is supplied

Description: The median value of a list is the value where there are an equal number of larger and smaller elements. If list contains an even number of elements, med returns the average of the two central values. If the central two elements are not numbers, med returns the first of these two.

Examples: med([1,2,3,4,5]) = 3

med(1,2,3,4,5) = 3

med([1,2,3,4,5,6]) = 3.5

med(["a","b","c"]) = b

med(["a","b","c","d"]) = b

See Also: pct, max, min, count, sum, prod, avg, std, variance, bin

  Demand Planning  |  Financial Forecasting
Forecasting Software  |  Strategic Planning Software  |  Decision Tree Software
Decision Support Software  |  Expert System Software  |  Online Surveys

Contact Us  |  Terms of Use  |  Privacy Policy  |  Site Map
Vanguard Software
© 2011 Vanguard Software Corporation
Print this page   Email this page to a friend