Link to home
Start Free TrialLog in
Avatar of m3housing
m3housing

asked on

Calculate quartiles and mean in mysql

Hi guys

I was wondering if there was a good way of calculating mean and lower and upper quartile in mysql? Or if not, perhaps somebody has a quick way of doing it in code? I am accessing mysql from ColdFusion.

Thanks
ASKER CERTIFIED SOLUTION
Avatar of star_trek
star_trek

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of m3housing
m3housing

ASKER

Thanks guys - both answers were v helpful so I have split the points - I think the CF approach is better for my needs though. Thanks for the quick reply!