View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Sloth Sloth is offline
external usenet poster
 
Posts: 252
Default Third Quartile (75th Percentile

This seems an odd way to do this, but apparantly there is no universally
accepted method for quartile so you can't say Excell is incorrect in doing it
this way. I copied and pasted the following from
http://www.staff.city.ac.uk/r.j.gerr...elfaq/faq.html

If the data are assumed to be in ascending order,
- the lower quartile (Q1) is the ¼(n+3)th observation
- the second quartile (median) is the ½(n+1)th observation
- the upper quartile (Q3) is the ¼(3n+1)th observation
When ¼(n+3), ½(n+1) and ¼(3n+1) are not integers, linear interpolation is
used.