49.01 |
2.20 |
16.70 |
93.97 |
6.16 |
27.75 |
5 |
12 |
8 |
14 |
9 |
4 |
The weighted mean is 36.2898.
C1 | C2 | C3 |
---|---|---|
Data | Weights | Weighted Mean |
49.01 | 5 | 36.2898 |
2.20 | 12 | |
16.70 | 8 | |
... | ... |
You must calculate the weighted mean before you calculate the weighted standard deviation.
The square of the weighted standard deviation is the weighted variance.
If the Weights column contains a 0, you will get an error because you can't divide by 0.
The weighted standard deviation is 41.0060.
C1 | C2 | C3 | C4 |
---|---|---|---|
Data | Weights | Weighted Mean | Weighted SD |
49.01 | 5 | 36.2898 | 41.0060 |
2.20 | 12 | ||
16.70 | 8 | ||
... | ... |