How to compute weighted average

13 次查看(过去 30 天)
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.

采纳的回答

KSSV
KSSV 2021-5-10
A = [54 50 ; 40 60 ; 30 70] ;
A(:,3) = 0.4*A(:,1)+0.6*A(:,2)

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Tables 的更多信息

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by