May I know if there is a function for median and upper quartile of a set of data in MS Access?
A Andy Chan Nov 19, 2005 #1 May I know if there is a function for median and upper quartile of a set of data in MS Access?
D Douglas J. Steele Nov 19, 2005 #2 Sorry, no there isn't. There's code at http://support.microsoft.com/?id=210581 to calculate Median. Similar code can be used to calculate quartiles.
Sorry, no there isn't. There's code at http://support.microsoft.com/?id=210581 to calculate Median. Similar code can be used to calculate quartiles.
J James A. Fortune Nov 20, 2005 #3 Andy said: May I know if there is a function for median and upper quartile of a set of data in MS Access? Click to expand... In: http://groups.google.com/group/comp.databases.ms-access/msg/7fb6eb508f22fa9d I give a SQL technique for finding the medians of sets of values returned by a GROUP BY clause. Perhaps it will give you a starting point. James A. Fortune
Andy said: May I know if there is a function for median and upper quartile of a set of data in MS Access? Click to expand... In: http://groups.google.com/group/comp.databases.ms-access/msg/7fb6eb508f22fa9d I give a SQL technique for finding the medians of sets of values returned by a GROUP BY clause. Perhaps it will give you a starting point. James A. Fortune
