Select specific rows and compare

Good Morning everyone.

I have been working on this and I could not make it work. I have of n options with 1000 simulation results as columns: (1)simulation, (2)options, (3)x-value, (4)y-value

     1         1       x1      y1
     1         2       x2      y2
     ...       ...     ...     ...
     1         n       Xn       Yn
     2         1       ...      ...
     ...       ...     ...      ...
     1000      n

Basically, matrix was sorted by simulation in column 1 and options in column 2. I need to write a code to pairwise between options and compare x-value and y-value. For example, pair option 1 and option 2, if x1 < x2 && y1 > y2, result is 1 else 0.

So final matrix should (suggested) column as (1)Simulation,(2)Pair 1&2,(3)Pair 1&3,..., (n)Pair 1&n, (n+1)Pair 2&3, ... pair (n-1,n)

    1          0      1    ...    1    1     0     
   ...                          result of 1, 0
   1000

Moreover, I would like to ask if MathLab can do T-test. I want to compare the final results of each pairwise using T-test in order to see significant of each pairwise results.

Thank you very much.

[dpb]

This appears to be the same basic problem as just raised in another very recent thread...

http://www.mathworks.com/matlabcentral/answers/156670-how-can-i-subtract-columns-for-each-row-by-using-a-for-loop

[Leandro]

Let me understand, for each simulation you have a even number of results and you want to compare them and put it in columns in the same row numbered by the simulation. Is it?

[OoM]

Yes in each simulation, all options have their own x and y value which I would like to compare and save compared results again separately.