Answer the question
In order to leave comments, you need to log in
Am I calculating the weighted average correctly?
I have a list of apartments in this format:
SC
10 sq.m. - 1,000,000 rubles
20 sq.m. - 2,000,000 rubles
30 sq.m. - 3,000,000 rubles.
To calculate the weighted average value of the cost of an apartment, I need to:
1) calculate the sum of the product of the area * cost
2) calculate the sum of all prices
3) divide 2) by 1)?
UPD. In general, such a task: there are three lists (one-room, two-room, three-room apartments) with a total area and price. It is necessary in each of the categories to find the average cost of an apartment, the average cost per square meter. Then find the average cost for the entire city. In addition, there are anomalous values in the list, and there is a task to get rid of them.
Here's what I think is the best way to do it.
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question