Hi guys,
I need to understand how to perform a weighted average with the following example.
I have three columns in the following example table:
id m f
'a' 54 50
'b' 40 60
'c' 30 70
The question is: how do I create a third column (named wa), which computes the weighted average (m = 40%) + (f = 60%) and transfer it to this third column?
In this example my final table will be:
id m f wa
'a' 54 50 51.6
'b' 40 60 52
'c' 30 70 54
Thanks in advance.