Excel Magic Trick 1207: PERCENTILE.EXC, PERCENTILE.INC, QUARTILE.EXC, QUARTILE.INC Functions скачать в хорошем качестве

Excel Magic Trick 1207: PERCENTILE.EXC, PERCENTILE.INC, QUARTILE.EXC, QUARTILE.INC Functions

Download Excel Start File: https://excelisfun.net/files/EMT1206-... Download File: https://excelisfun.net See how to use the different percentile and quartile functions in Excel:: 1. (00:11) What is a percentile? 2. (00:47) Difference between PERCENTILE.EXC and PERCENTILE.INC functions AND the difference between the QUARTILE.EXC and QUARTILE.INC functions. 3. (2:30) Algorithm for calculating position of item in list for .EXC function and .INC function. Why the two functions calculate different answers. 4. (06:13) PERCENTILE.EXC function 5. (06:28) PERCENTILE.INC function 6. (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. 7. (08:30) QUARTILE.EXC function 8. (09:12) QUARTILE.INC function 9. (09:44) Create Defined Name with the Create Name From Selection feature 10. (10:38) Five Number Summary with PERCENTILE.EXC and PERCENTILE.INC and QUARTILE.EXC and QUARTILE.INC