Access Query for Low, Median, and High numbers

  • Thread starter Thread starter Pat Diminico
  • Start date Start date
P

Pat Diminico

I have a table with data. I need to build a query that
will give me the low, median, and high value based on a
column of data. What is the proper function or VB needed
to make this happen?

Thanks

Pat
 
Hi Pat,

Thanks for your post. Based on your description, I am not quite clear what
you want to do. How do you define the value in the column is low, median or
high? Can you use where clause in the query to filter the data? Does it
meet your requirements?

It is best that you can provide a specific sample so that it can help us
fully understand your concerns and work with you more efficiently.

I am looking forward to hearing from you soon.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
 
When I state Low, Median, or High keep the following in
mind:
Low = 25th
Median = 50th
High = 75th

Here is an explaination I found on the Net:

"The median is the middle of a distribution: half the
scores are above the median and half are below the median.
The median is less sensitive to extreme scores than the
mean and this makes it a better measure than the mean for
highly skewed distributions. The median income is usually
more informative than the mean income, for example.

When there is an odd number of numbers, the median is
simply the middle number. For example, the median of 2, 4,
and 7 is 4.

When there is an even number of numbers, the median is the
mean of the two middle numbers. Thus, the median of the
numbers 2, 4, 7, 12 is (4+7)/2 = 5.5."

Hope this helps explain wjat I am looking for.

Thanks

Pat
 
Hi Pat,

Thanks for your feedback. I understand that you want to derive a
statistical median from a column of data. If I have misunderstood, please
feel free to let me know.

This article shows you how to create a Visual Basic for Applications
procedure to open a table, read the data, and find the statistical
<median>. The median is a measure of central tendency, another "middle"
measurement of a data set, like the mean or average). The data set
consisting of the numbers 1, 2, 3, 6, and 100 has a median of 3, the middle
of the set. The data set consisting of the numbers 1, 2, 6, and 10 has a
median of 4, the middle of the set [(2 + 6) / 2 = 4].

210581 ACC2000: How to Use Code to Derive a Statistical Median
http://support.microsoft.com/?id=210581

As to the low and high value, we just need to change the target data derive
them.

Please feel free to post in the group if this solves your problem or if you
would like further assistance.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
 
Back
Top