GuidePedia

0
MEDIAN function returns median of the given set of values. When you sort a list of values from smallest to largest, median is in the middle of this list. If you have even number of values, e.g. 1, 4, 5, 6, the median is 4.5 (4+5/2).
Syntax
= MEDIAN (number1, [number2], ...)
number1 - First number or range of numbers.
number2 - [Optional] Second number or range of numbers.
Examples
=MEDIAN(B2:F3) returns 1.95, because MEDIAN of the list of numbers:
0.1, 0.3, 0.5, 0.7, 0.9, 3, 5, 10, 34, 78. is (0.9 + 3) / 2.

Use
The median is widely used in statistics where might be seen as a better indication of central tendency than arithmetic mean.

Post a Comment

Blogger Tips and TricksLatest Tips And TricksBlogger Tricks

Visitors

Cloud Power For You

Website Hosting At Low Price

Contatc

Empire Views
 
Top