Vanguard Software
Forecasting & Planning Solutions

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

  Forecasting Software  |  Strategic Planning Software  |  Decision Support Software
Decision Tree Software  |  Monte Carlo Simulation Software  |  Risk Analysis Software
Portfolio Analysis  |  Expert System Software  |  Online Questionnaires

Contact Us  |  Terms of Use  |  Privacy Policy  |  Site Map
Vanguard Software
© 2010 Vanguard Software Corporation
Home Products Solutions Services Customers Partners Company
Vanguard
Applying science to business management
Vanguard
Print this page   Email this page to a friend