Türk İngilizce
ORTANCA MEDIAN

General Information about the MEDIAN Function

The MEDIAN function in Excel and Google Sheets is used to find the middle value in a given set of numbers. This function sorts the data from smallest to largest and returns the value in the middle. If there is an even number of values, it calculates the average of the two middle numbers.

Syntax and Examples

Syntax for Excel and Google Sheets:

 MEDIAN(number1, [number2], ...)

In this function, the arguments “number1”, “number2”, …, “numbern” can be numeric values or cell references containing numeric values.

Example Usage

  • =MEDIAN(1, 3, 5, 7) // Result: 4

    In this example, the sequence of numbers is 1, 3, 5, 7. The middle numbers are 3 and 5, hence their average is taken: (3+5)/2 = 4.

  • =MEDIAN(2, 4, 6) // Result: 4

    In this instance, the numbers are sorted as 2, 4, 6 and the median value is directly 4, as it is the middle number.

Practical Applications

1. Finding the Median in a Data Set

When performing data analysis, particularly with large data sets containing many data points, finding the median value can be beneficial. The median is less affected by outliers and can more accurately reflect the distribution of a data set.

 Example Data Set: 5, 2, 9, 4, 7, 3, 8 Excel or Google Sheets Formula: =MEDIAN(5, 2, 9, 4, 7, 3, 8) This formula sorts the given numbers from smallest to largest and calculates the median, resulting in 5. 

2. Use of Median in Economics and Finance

In the field of economics or finance, calculating the median income while studying the income levels of a group of people can be very useful. The median income is an important indicator in understanding the distribution of earnings within a society.

 Example Data Set: 1500, 1200, 1800, 900, 950 Excel or Google Sheets Formula: =MEDIAN(1500, 1200, 1800, 900, 950) This formula sorts the numbers from smallest to largest and calculates the median, finding the result as 1200. 

Daha fazla bilgi: https://support.microsoft.com/tr-tr/office/ortanca-işlevi-d0916313-4753-414c-8537-ce85bdd967d2

Diğer fonksiyonlar
Bağımsız değişkenler listesinde kaç tane değer bulunduğunu sayar
Bağımsız değişkenler listesinde kaç tane sayı bulunduğunu sayar
Aralıktaki boş hücre sayısını hesaplar
Verilen birden çok ölçüte uyan bir aralık içindeki boş olmayan hücreleri sayar
Verilen ölçütlere uyan bir aralık içindeki boş olmayan hücreleri sayar
İki veri kümesi arasındaki bağlantı katsayısını verir
Doğrusal eğilim boyunca bir değer verir