Ninin, So, to take the average you'll need to divide by the count of valid data in the two rows at each position. gp1 gp2 sum 0.681 0.716 1.398 0.664 0.911 1.575 1.101 0.724 1.825 1.125 0.844 1.968 0.516 0.713 1.228 0.463 0.388 0.851 0.801 .... .... 0.651 0.899 1.550 0.715 0.795 1.510 0.656 0.580 1.237 and you could divide the variable sum by count for the average. Notice I used IFV in the definitions for gp1_good and gp2_good. This is a special version of IF, which is TRUE if the data is valid, even when the value itself is zero. Using just the IF command would return FALSE for valid values of exactly zero. yes? list IF {2., 0., 3} then 1 VARIABLE : IF {2., 0., 3} THEN 1 SUBSET : 3 points (X) 1 / 1: 1.000 2 / 2: .... 3 / 3: 1.000 yes? list IFV {2., 0., 3} then 1 VARIABLE : IFV {2., 0., 3} THEN 1 SUBSET : 3 points (X) 1 / 1: 1.000 2 / 2: 1.000 3 / 3: 1.000 On 8/20/2014 3:46 AM, Nitin Patil
wrote:
|