Formulas and Functions
এই নিয়ন্ত্রণ পরিবর্তন করলে এই পেজটি স্বয়ংক্রিয়ভাবে আপডেট হবে

MEDIAN

The MEDIAN function returns the median value in a set of numbers. The median is the value where half the values in the set are less than the median and half are greater.

MEDIAN(value, value…)

value: Any value or collection. Date/time values or duration values can’t be mixed with other value types. If either of these value types is included, all values must be of the same value type. A string value or boolean value can be included in a referenced cell, but can’t be entered directly as an argument to the function.

value…: Optionally include one or more additional values or collections.

Notes

  • A string value or boolean value included in a referenced cell is not considered in determining which value is the maximum value.

  • If there is an even number of values in the set, the MEDIAN function returns the average of the two middle values.

Examples

=MEDIAN(1, 2, 3, 4, 5) returns 3.

=MEDIAN(1, 2, 3, 4, 5, 6) returns 3.5.

=MEDIAN(5, 5, 5, 5, 6) returns 5.

See alsoAVERAGEMODE
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
কাজে লেগেছে?
অক্ষর সীমা: 250
সর্বাধিক অক্ষর সীমা 250।
আপনার মতামতের জন্য ধন্যবাদ।
Morty Proxy This is a proxified and sanitized view of the page, visit original site.