jamiguel77
Active Member
- Joined
- Feb 14, 2006
- Messages
- 387
- Office Version
- 2016
- 2010
- 2007
- Platform
- Windows
- Web
hi all, how to calculate: weighted average
The table below shows the population by country that owns dogs, (and how many)
with this data:
the result would be on: c17
An explanation of the weighted average?
thanks
The table below shows the population by country that owns dogs, (and how many)
with this data:
Libro5 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
10 | No Person | Qty Dogs | ||||
11 | Argentina | 1,000 | 60,000 | |||
12 | USA | 10 | 700 | |||
13 | Mexico | 5,000 | 90,000 | |||
14 | 6,010 | 150,700 | ||||
15 | ||||||
16 | Average: | 25.07487521 | ||||
17 | Weighted average: | |||||
18 | ||||||
Hoja3 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B14:C14 | B14 | =SUM(B11:B13) |
C16 | C16 | =C14/B14 |
the result would be on: c17
An explanation of the weighted average?
thanks