Table of contents:
Video: The weighted average - what is it and how to calculate it?
2024 Author: Henry Conors | [email protected]. Last modified: 2024-02-12 02:41
In the process of studying mathematics, students get acquainted with the concept of the arithmetic mean. In the future, in statistics and some other sciences, students are also faced with the calculation of other averages. What can they be and how do they differ from each other?
Mean values: meaning and differences
Not always accurate indicators give an understanding of the situation. In order to assess this or that situation, it is sometimes necessary to analyze a huge number of figures. And then averages come to the rescue. They allow you to assess the situation in general.
Since school days, many adults remember the existence of the arithmetic mean. It is very easy to calculate - the sum of a sequence of n terms is divisible by n. That is, if you need to calculate the arithmetic mean in the sequence of values 27, 22, 34 and 37, then you need to solve the expression (27 + 22 + 34 + 37) / 4, since 4 values \u200b\u200bare used in the calculations. In this case, the desired value will be equal to 30.
The geometric mean is often studied as part of the school course. The calculation of this value is based on extracting the root of the nth degree from the productn-members. If we take the same numbers: 27, 22, 34 and 37, then the result of the calculations will be 29, 4.
The harmonic mean in a comprehensive school is usually not a subject of study. However, it is used quite often. This value is the reciprocal of the arithmetic mean and is calculated as a quotient of n - the number of values and the sum 1/a1+1/a2+…+1/a. If we again take the same series of numbers for calculation, then the harmonic will be 29, 6.
Weighted average: features
However, all of the above values may not be used everywhere. For example, in statistics, when calculating some average values, the "weight" of each number used in calculations plays an important role. The results are more revealing and correct because they take into account more information. This group of values is collectively referred to as the "weighted average". They are not passed at school, so it is worth dwelling on them in more detail.
First of all, it is worth explaining what is meant by the "weight" of a value. The easiest way to explain this is with a specific example. The body temperature of each patient is measured twice a day in the hospital. Of the 100 patients in different departments of the hospital, 44 will have a normal temperature - 36.6 degrees. Another 30 will have an increased value - 37.2, 14 - 38, 7 - 38.5, 3 - 39, and the remaining two - 40. And if we take the arithmetic mean, then this value in general for the hospital will be over 38degrees! But almost half of the patients have a completely normal temperature. And here it would be more correct to use the weighted average, and the "weight" of each value will be the number of people. In this case, the result of the calculation will be 37.25 degrees. The difference is obvious.
In the case of weighted average calculations, the "weight" can be taken as the number of shipments, the number of people working on a given day, in general, anything that can be measured and affect the final result.
Varieties
The weighted average corresponds to the arithmetic average discussed at the beginning of the article. However, the first value, as already mentioned, also takes into account the weight of each number used in the calculations. In addition, there are also geometric and harmonic weighted averages.
There is another interesting variation used in series of numbers. This is a weighted moving average. It is on its basis that trends are calculated. In addition to the values themselves and their weight, periodicity is also used there. And when calculating the average value at some point in time, the values for previous time periods are also taken into account.
The calculation of all these values is not that difficult, but in practice only the usual weighted average is usually used.
Calculation methods
In the age of computerization, there is no need to manually calculate the weighted average. However, it would be useful to know the calculation formula so that you cancheck and, if necessary, correct the results obtained.
It will be easiest to consider the calculation on a specific example.
Salary (thousand rubles) | Number of workers (persons) |
32 | 20 |
33 | 35 |
34 | 14 |
40 | 6 |
It is necessary to find out what is the average wage at this enterprise, taking into account the number of workers receiving this or that income.
So, the weighted average is calculated using the following formula:
x=(a1w1+a2w 2+…+a w)/(w1+w 2+…+w)
For an example, the calculation will be as follows:
x=(3220+3335+3414+406)/(20+35+14+6)=(640+1155+476+240)/75=33, 48
Obviously, it's not too hard to manually calculate the weighted average. The formula for calculating this value in one of the most popular applications with formulas - Excel - looks like the SUMPRODUCT (series of numbers; series of weights) / SUM (series of weights) function.
Recommended:
How to calculate resource endowment? Resource supply of Russia and the USA. Resource availability is
Resource availability is a quantitative relationship between the amount of natural resources and the amount of their consumption. The concept of "natural resources" refers to those components of nature that are used or can be used to meet various human needs. The past twentieth century is characterized by an unprecedented increase in the world's population and world social production, and the achievements of modern scientific technologies have an increasing impact on the environment
Working capital ratio: what is it and how to calculate
The working capital ratio reveals whether the enterprise has enough of its own funds, which are necessary for its financial stability. The presence of a business entity's capital is one of the most important conditions for the effective operation of an enterprise. It belongs to the group of coefficients that determine the financial stability of the organization
A man of average height. What is considered average height for a man?
"God, how the men were crushed!" Do you know this exclamation? Interestingly, is it really the male population that is getting lower, or does it just seem like that to the ladies who have grown up and climbed on their heels? We will talk about what a man of average height is and what exactly determines this indicator in the world and in our country in the article
On which days you can not get pregnant and how to calculate them?
Of course, every girl at least once was interested in the question of which days the fertilization of the egg is impossible and whether there is a risk of getting pregnant during the "critical" days. All of the above is an integral part of such a thing as a calendar method of contraception. What does he represent? It is used in cases where a woman does not want to have children yet ( although not very reliable)
How to calculate the day of ovulation. How to accurately calculate the first day of ovulation
The female body is a very complex and perfect system. Ideally, every month a he althy cell comes out of the ovary, from which all the cells of the new organism are formed. But, unfortunately, in life there are many factors that can affect this complex process. Therefore, there are many ways that help you figure out how to calculate the day of ovulation