Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Boxplots?
2 views
Skip to first unread message
Philip
Apr 13, 2006, 7:41:01 PM4/13/06
to
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.
--
Regards
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.
--
Regards
Philip
James A. Fortune
Apr 21, 2006, 2:06:44 PM4/21/06
to
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
MPAP...@FortuneJames.com
Philip
Apr 23, 2006, 5:45:01 AM4/23/06
to
James
This looks like exactly what I needed.
Much appreciated.
--
Regards
Philip
0 new messages