Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Quartiles
I have both Excel XP and 2007 and neither does even numbered count Quartile
functions correctly. What gives? Why hasn't Microsoft fixed this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Computing Quartiles with Excel 2007 | Excel Discussion (Misc queries) | |||
Upper and lower Quartiles? | Excel Discussion (Misc queries) | |||
graphing quartiles..does anyone have a source for how to do this? | Charts and Charting in Excel | |||
QUARTILES in Excel | Excel Worksheet Functions | |||
Calculation Method for Quartiles | Excel Worksheet Functions |