Thread: Quartiles
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default Quartiles

Mike,

There is no generally agreed upon method for determining quartiles - if you are not happy with
Excel's default, then choose your own method and implement it through a UDF in VBA.

http://mathworld.wolfram.com/Quartile.html

HTH,
Bernie
MS Excel MVP


"Mike Dobony" wrote in message
. ..
I have both Excel XP and 2007 and neither does even numbered count Quartile
functions correctly. What gives? Why hasn't Microsoft fixed this?