Boxplots?

[Guest]

I am a prodigal son returning to Access after being away for several years.
This time, I aim to become fluent in VBA. In the meantime, I need to know if
there is a way to persuade Acess 2003 to produce boxplots that show the lower
quartile, median and upper quartiles of a set of values. I can't find
anything in Excel that relates to this either.

 

[James A. Fortune]

I am a prodigal son returning to Access after being away for several years.
This time, I aim to become fluent in VBA. In the meantime, I need to know if
there is a way to persuade Acess 2003 to produce boxplots that show the lower
quartile, median and upper quartiles of a set of values. I can't find
anything in Excel that relates to this either.

In:

http://groups.google.com/group/comp.databases.ms-access/msg/7fb6eb508f22fa9d

I presented a way to get the medians of GROUP BY data using SQL. A
similar technique should work for getting lower and upper quartile values.

James A. Fortune
(e-mail address removed)

 

[Guest]

James

This looks like exactly what I needed.

Much appreciated.