finding the computation for n columns

Hi

Given a a vector table z with column and row of 1200 and 1200 respectively

I want to compute the following for each rows

z = ( T R S T V............n column)

first column T

K = 3;

c1 = sort(T.distance(1:2:end));

c2 = sort(T.distance(2:2:end));

s1 = sum(c1(1:K))/sum(c2(1:K )) ;

second column R

K = 3;

c1 = sort(R.distance(1:2:end));

c2 = sort(R.distance(2:2:end));

s2 = sum(c1(1:K))/sum(c2(1:K )) ;

disp(s2);

How do I make this computation using a small code for n columns

Thank you in advance

Tino

Answer 1

[madhan ravi]

Z=z{:,:};
K = 3;
c1 = sort(Z(1:2:end,:)); 
c2 = sort(Z(2:2:end,:)); 
s1 = sum(c1(1:K,:))./sum(c2(1:K,:))

[madhan ravi]

Thanks Madhan

But I am getting this error when I try to compute

J = Z{:,:};
K = 3;
c1 = sort(J(1:2:end,:)); 
c2 = sort(J(2:2:end,:)); 
s1 = sum(c1(1:K,:))/sum(c2(1:K,: )) ;
disp(s1);
Error
Brace indexing is not supported for variables of this type.
Error in martingale (line 35)
J = Z{:,:};

Thanks in advance

[madhan ravi]

not Z it's z

[Tino]

Hi Madhan

Am still geting the problem

What shall I do

thanks in advance

Brace indexing is not supported for variables of this type.

Error in martingale (line 37)

J = z{:,:};

[madhan ravi]

Attach your table as .mat file.

[madhan ravi]

HI Madhan

I have attached the table below consisting of 1200 rows and 1200 column

the code is to computation for each column

and I am suppose to get 1200 answers

thanks in advance

[madhan ravi]

I'm not able to open your file (try once again) , please don't add an answer just to make a comment

[Tino]

sorry that was an error. Let me add the file again

thanks you in advance

[madhan ravi]

Having trouble opening your file.

[Tino]

Hi Madhan

I had attached the excel file

Hope that is ok

Thanks for your help in advance

Tino

[Tino]

Hi Madhan

Can you see the data now?

Thanks

tino

[madhan ravi]

No , I am not able to , there‘s some problem downloading files in my mac.