Türk İngilizce
KIRPORTALAMA TRIMMEAN

The TRIMMEAN function in Microsoft Excel and Google Sheets enables users to compute a more robust average by excluding outliers (the highest and lowest values) from a data set. This function allows you to specify the percentage of data to exclude from the top and bottom of your data set and then calculates the mean of the remaining data. Here is a detailed guide.

Features and Syntax

TRIMMEAN(array, percent)

  • array: The array or range of data to compute the mean of.
  • percent: The fraction of data points to exclude as outliers. For example, entering 0.1 will exclude 10% of the data set (5% from the top and 5% from the bottom).

How to Use the Function

Imagine you want to calculate the average salary of employees in a company, but you wish to exclude extremely high or low salaries to prevent them from skewing the overall average. Here’s how you can apply it:

Employee Salary
Ahmet 3000
Burcu 3400
Cem 5000
Deniz 2200
Elif 1800
=TRIMMEAN(A2:A6, 0.2)

In this example, the lowest 10% and the highest 10% of salaries are excluded, and the mean is calculated from the remaining salaries. With a percent value of 0.2 (20%), one highest and one lowest salary are removed, and the average is computed from the remaining three salaries.

Practical Applications

1. Calculating Adjusted Average Exam Scores

A class’s exam scores vary significantly, and the teacher wants to see a realistic average:

Scores = [55, 90, 76, 59, 98, 84, 75, 65, 97, 83]

In theory, the best and worst 20% of scores are excluded from the calculation:

=TRIMMEAN(Scores, 0.2)

2. Average Monthly Revenues of a Company

The company”s monthly revenue figures are as follows:

Revenues = [12000, 15000, 13000, 125000, 14000, 13500, 130000, 14500]

When extraordinary high or low figures are present, these measurements are excluded from the computation by:

=TRIMMEAN(Revenues, 0.25)

In this scenario, the lowest and highest 25% of revenue figures are excluded, and the average is calculated from the remaining data.

The TRIMMEAN function is an extremely useful tool in data analysis and decision-making processes for obtaining more representative average values, especially crucial in fields like economics, finance, science, and engineering where outliers may distort analyses.

Daha fazla bilgi: https://support.microsoft.com/tr-tr/office/kirportalama-işlevi-d90c9878-a119-4746-88fa-63d988f511d3

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