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