search for: xnumber

...I am trying to calculate inter-environment correlation (rF = cov A,B / sq.root(varA * varB ) for each row of the dataset. the values needed are (in 80 of the columns 2*40) in columns 174-213, and 214-253 respectively which represent two environments (A or B). Each of those columns is labelled with Xnumber.A/B e.g. X208.A is column 174 (which also relates to the first column in the B environment groups, col.214, X208.B) effectively the equation is: rF= cov (columns[174:213] , [214:253]) / sqrt( (var[174:213]) * (var[214:253]) ) I want each of the 13890 rows to then have the rF value...

...boolean=Q unique=Q field=uniqueid objectid: field=objectid boolean=XID value=0 objecttype: field=type boolean=XTYPE language: field=language boolean=L title: field=title index content: index catalog: field=catalog boolean=XCATALOG number: field=number searchnumber: field=searchnumber boolean=XNUMBER indexnopos productgroup: field=productgroup boolean=XPRODUCTGROUP property: field=property boolean=XPROPERTY colour: field=colour boolean=XCOLOUR size: field=size boolean=XSIZE colourandsize: field=size boolean=XCOLOURANDSIZE norm: field=norm boolean=XNORM picture: field=picture sort: valu...