Re: [GENERAL] Q:Aggregrating Weekly Production Data. How do you do it?

2007-09-19 Thread Scott Marlowe
On 9/18/07, Ow Mun Heng <[EMAIL PROTECTED]> wrote: > On Tue, 2007-09-18 at 09:55 -0500, Scott Marlowe wrote: > > On 9/17/07, Ow Mun Heng <[EMAIL PROTECTED]> wrote: > > > > > Just wondering how everyone is doing aggregration of production data. > > > > Where I work, we aggregate by the minute in the

Re: [GENERAL] Q:Aggregrating Weekly Production Data. How do you do it?

2007-09-18 Thread Ow Mun Heng
On Tue, 2007-09-18 at 09:55 -0500, Scott Marlowe wrote: > On 9/17/07, Ow Mun Heng <[EMAIL PROTECTED]> wrote: > > > Just wondering how everyone is doing aggregration of production data. > > Where I work, we aggregate by the minute in the application, then dump > those stats entries into the databa

Re: [GENERAL] Q:Aggregrating Weekly Production Data. How do you do it?

2007-09-18 Thread btober
Ow Mun Heng wrote: > Data which runs in the vicinity of a few million a week. > > What are the methods which will effectively provide the > min/max/average/count/stdev of the weekly sample size based on different > products/software mix etc. > > and still be able to answer correctly, what's the av

Re: [GENERAL] Q:Aggregrating Weekly Production Data. How do you do it?

2007-09-18 Thread Scott Marlowe
On 9/17/07, Ow Mun Heng <[EMAIL PROTECTED]> wrote: > Just wondering how everyone is doing aggregration of production data. Where I work, we aggregate by the minute in the application, then dump those stats entries into the database en masse from each machine. So, we wind up with rows something l

Re: [GENERAL] Q:Aggregrating Weekly Production Data. How do you do it?

2007-09-18 Thread John D. Burger
Ow Mun Heng wrote: The results are valid (verified with actual data) but I don't understand the logic. All the Statistical books I've read marked stdev as sqrt (sum(x - ave(x))^2 / (n - 1). The formula is very different, hence the confusion. A formula is not an algorithm. In particular, the

Re: [GENERAL] Q:Aggregrating Weekly Production Data. How do you do it?

2007-09-18 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/17/07 23:34, Ow Mun Heng wrote: > Just wondering how everyone is doing aggregration of production data. > > Data which runs in the vicinity of a few million a week. > > What are the methods which will effectively provide the > min/max/average/c

[GENERAL] Q:Aggregrating Weekly Production Data. How do you do it?

2007-09-17 Thread Ow Mun Heng
Just wondering how everyone is doing aggregration of production data. Data which runs in the vicinity of a few million a week. What are the methods which will effectively provide the min/max/average/count/stdev of the weekly sample size based on different products/software mix etc. and still be