| 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 | |||
Linear Mode
