Question: what is the difference between the functions quartile.inc() and quartile.exc()?
Answer: The 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.