Q: Using quartiles in Numbers
I'm trying to figure out the first and third quartile from a long list of different values, by using Numbers. I've already done it once in Excel, but for some reason I can't get the same result in Numbers. In Excel my first quartile is 40%, but when I do it with the same exact values in Numbers, I get 41%. When I try to find the third quartile the result is 57% in Excel, and 55% in Numbers. I've copied the list of values from Excel, so I'm sure there's no mistake with any numbers missing or anything like that. The list has 80 values in it, though that really shouldn't matter. Would be great if anyone knew what is going on with this!
MacBook Pro (Retina, 13-inch, Mid 2014), OS X El Capitan (10.11.6)
Posted on Oct 6, 2016 12:32 PM
Excel has multiple quartile functions, as described here.
QUARTILE.ESC, QUARTILE.INC and QUARTILE have subtle differences.
QUARTILE.ESC excludes the median when determining interpolation. QUARTILE.INC and QUARTILE include the median.
The QUARTILE function in Excel and in Numbers give the same results on my machine.
SG
Posted on Oct 7, 2016 9:41 AM



