Re: Stdev calculation for aggregrate tables

2007-04-04 Thread Peter Brawley
Ow Mun Heng, If you reduce your algorithm to a fromula, I think you'll find it's algebraically equivalent to the formula you quote. PB Ow Mun Heng wrote: Hi, I'm looking at creating some aggregrate table based on ~2hr pull from the main DB and looking to get standard stuffs like min/max/av

Stdev calculation for aggregrate tables

2007-04-04 Thread Ow Mun Heng
Hi, I'm looking at creating some aggregrate table based on ~2hr pull from the main DB and looking to get standard stuffs like min/max/ave etc. I'm having some issues with getting stdev which would be representative of the stdev of say 10 hours of data. >From this website : (it references using S