Excel Magic Trick 1207


PERCENTILE.EXC, PERCENTILE.INC, QUARTILE.EXC, QUARTILE.INC

DESCRIPTION

See how to use the different percentile and quartile functions in Excel::
(00:11) What is a percentile?
(00:47) Difference between PERCENTILE.EXC and PERCENTILE.INC functions AND the difference between the QUARTILE.EXC and QUARTILE.INC functions.
(02:30) Algorithm for calculating position of item in list for .EXC function and .INC function. Why the two functions calculate different answers.
(06:13) PERCENTILE.EXC function
(06:28) PERCENTILE.INC function
(06:45) Why .EXC function yields error when you try to calculate the Min and Max values AND why .INC function does not yield an error.
(08:30) QUARTILE.EXC function
(09:12) QUARTILE.INC function
(09:44) Create Defined Name with the Create Name From Selection feature
(10:38) Five Number Summary with PERCENTILE.EXC and PERCENTILE.INC and QUARTILE.EXC and QUARTILE.INC

WORKBOOKS




Be the first to comment

Leave a Reply