I am looking for a way to calculate for the median of
data.
Example:
I have data being imported into my database from several
files (at the most 9 files) with two headers, "data1 and
data2". There are 170 records in each file. I want to
chart the median of data1 and data2. How do I calculate
the median?
The files are set up in this way:
Data1 data2
1 .9
2 1.8
3 .87

ACC2000: Reporting the Median Value of a Group of Records
http://support.microsoft.com/default.aspx?scid=kb;en-
us;209244&Product=acc2000

Hope that helps...

DBS

>-----Original Message-----
>I am looking for a way to calculate for the median of
>data.
>Example:
>I have data being imported into my database from several
>files (at the most 9 files) with two headers, "data1 and
>data2". There are 170 records in each file. I want to
>chart the median of data1 and data2. How do I calculate
>the median?
>The files are set up in this way:
>Data1 data2
>1 .9
>2 1.8
>3 .87
>
>.
>

I guess I didn't tell you all the details. The
information you gave me is good, but I need to get the
median across a row not a column. Is this possible?
>-----Original Message-----
>ACC2000: Reporting the Median Value of a Group of Records
>http://support.microsoft.com/default.aspx?scid=kb;en-
>us;209244&Product=acc2000
>
>Hope that helps...
>
>DBS
>
>>-----Original Message-----
>>I am looking for a way to calculate for the median of
>>data.
>>Example:
>>I have data being imported into my database from
several
>>files (at the most 9 files) with two headers, "data1
and
>>data2". There are 170 records in each file. I want to
>>chart the median of data1 and data2. How do I
calculate
>>the median?
>>The files are set up in this way:
>>Data1 data2
>>1 .9
>>2 1.8
>>3 .87
>>
>>.
>>
>.
>