Question: what is the difference between inclusive and exclusive quartiles?
Answer: EXC and QUARTILE. ... The difference between these two functions is that QUARTILE. INC bases its calculation on a percentile range of 0 to 1 inclusive, whereas QUARTILE. EXC bases its calculation on a percentile range of 0 to 1 exclusive.