Assign rank to matrix and compare it

I want to be able to assign a rank to numbers in matrix, let say the matrix has 3 variable random static data. let's say i want to ranked the data from 1 to 5, from top to the bottom (not sort it), For example:

Name = {'Fred';'Betty';'Bob';'George';'Jane'};
Age = [38;43;38;40;38];
Height = [71;69;64;67;64];
Weight = [176;163;131;185;131];
A = table(Age,Height,Weight,'RowNames',Name)

the question:

1.How to assign the rank in the matrix like in the picture above?

2. How to compare the result? let's say i want compare Fred and Bob, i want the final result is Fred because according to the rank order he is rank 1.

Thanks

Answer 1

[KSSV]

Name = {'Fred';'Betty';'Bob';'George';'Jane'};
Age = [38;43;38;40;38];
Height = [71;69;64;67;64];
Weight = [176;163;131;185;131];
A = table(Age,Height,Weight,'RowNames',Name) ;
Rank = (1:5)' ; 

R = table(Rank) ; 
T = [A R] ; 
idx = min(T.Rank) ; 
A(idx,:)

[Paulus Soenarjo]

thanks so much, you really helpful this one answering my 1st question

but i don't really understand this part, because you just only choose the minimum value

how if i want to compare Betty with Bob, or Betty with George? Thanks

idx = min(T.Rank) ; 

[KSSV]

YOu can compare something like this:

T('Betty',4).(1) > T('Bob',4).(1)

[Paulus Soenarjo]

why when i put it to the code and it is keeping error

"Argument to dynamic structure reference must evaluate to a valid field name."

idx = T('Betty',4).(1) > T('Bob',4).(1);

[KSSV]

What version you are using.

[Paulus Soenarjo]

Matlab R2017a

[Paulus Soenarjo]

ok, finally after i upgraded my matlab to R2019a it's work! thanks so much