Stuart McLachlan
stuart at lexacorp.com.pg
Mon Jan 17 16:49:58 CST 2005
On 17 Jan 2005 at 23:27, Pedro Janssen wrote: > Hello Steve, > > i agree that it is a little fuzzy (and maybe strange to you) > but the evolutionary genetics specialist, specific asked for the Stdev > of each (in this case) AverageVal. So teh StDev for A1:B1, A1:B2, A1:B3. etc > I'll jope this explaines enough > OK, so he wants to know far apart the two values are in each pair. Since there are only two points in each set, you can simply the calculations considerably. A1:B1: Average = (A1+B1)/2 StDev = ABS(A1-B1)/2 etc -- Stuart