creating median of time period
 

I am working with water quality data organized by sample date, with samples
taken 2x/month. I need to sum the sampled parameter values for a time period
of interest, with the sample date being the median of that time period. How
do I create the time periods of interest when the samples are not recorded on
the same dates each month?
THanks

creating median of time period
 

Please supply a short list of sample dates, and whatever "time periods of
interest" you would like to see..........then perhaps someone can give you a
formula to automate the process.

Vaya con Dios,
Chuck, CABGx3



"LB" wrote:

I am working with water quality data organized by sample date, with samples
taken 2x/month. I need to sum the sampled parameter values for a time period
of interest, with the sample date being the median of that time period. How
do I create the time periods of interest when the samples are not recorded on
the same dates each month?
THanks

creating median of time period
 

10/13/2006
10/20/2006
11/11/2006
11/20/2006
12/7/2006
12/15/2006
1/12/2007

I need to capture time periods around the sample date, where the sample date
is the median. Make sense?
Thanks again
"CLR" wrote:

Please supply a short list of sample dates, and whatever "time periods of
interest" you would like to see..........then perhaps someone can give you a
formula to automate the process.

Vaya con Dios,
Chuck, CABGx3



"LB" wrote:

I am working with water quality data organized by sample date, with samples
taken 2x/month. I need to sum the sampled parameter values for a time period
of interest, with the sample date being the median of that time period. How
do I create the time periods of interest when the samples are not recorded on
the same dates each month?
THanks

creating median of time period
 

Not completely.............please give examples of the "Time periods" you
expect to see as a result of the shown dates..........

Vaya con Dios,
Chuck, CABGx3



"LB" wrote:


10/13/2006
10/20/2006
11/11/2006
11/20/2006
12/7/2006
12/15/2006
1/12/2007

I need to capture time periods around the sample date, where the sample date
is the median. Make sense?
Thanks again
"CLR" wrote:

Please supply a short list of sample dates, and whatever "time periods of
interest" you would like to see..........then perhaps someone can give you a
formula to automate the process.

Vaya con Dios,
Chuck, CABGx3



"LB" wrote:

I am working with water quality data organized by sample date, with samples
taken 2x/month. I need to sum the sampled parameter values for a time period
of interest, with the sample date being the median of that time period. How
do I create the time periods of interest when the samples are not recorded on
the same dates each month?
THanks