Download Excel File: https://excelisfun.net/files/Ch03-ESA.xlsm
Learn about calculating percentiles, quartiles, percentile rank and rank. Lean about two different algorithms for the percentile calculation. Learn about how to use eight different Excel built-in functions: ROWS, PERCENTILE.EXC, PERCENTILE.INC, MEDIAN, QUARTILE.EXC, QUARTILE.INC, PERCENTRANK.INC, RANK.AVG
Topics:
1. (00:00) Introduction
2. (00:18) What are Percentiles and Quartiles?
3. (01:30) Using PERCENTILE.EXC and PERCENTILE.INC functions to calculate percentiles
4. (02:38) What the “.EXC” and “.INC” dot extensions mean and what they represent
5. (05:29) Math Algorithm for PERCENTILE.EXC function
6. (05:36) Hide columns
7. (07:49) Math Algorithm for PERCENTILE.INC function
8. (08:24) Remove Number Formatting with General Number Formatting
9. (09:22) Calculating Median with the five different functions: PERCENTILE.EXC, PERCENTILE.INC, MEDIAN, QUARTILE.EXC, QUARTILE.INC
10. (09:35) Unhide columns
11. (10:06) Using the QUARTILE.EXC, QUARTILE.INC functions
12. (10:52) Using the , PERCENTRANK.INC function to calculate the percentile based on a marker in the data set.
13. (11:50) Using RANK.AVE to rank a number
14. (13:02) Creating a Five Number Summary for 490 rows of CPA score data using the functions PERCENTILE.INC and QUARTILE.INC.
15. (13:58) Compare Old School Formula Method and New School Method to calculate the five number summary using the QUARTILE.INC function
16. (05:13) Interpreting Five Number Summary
17. (16:22) Calculate percentile, percentile rank and rank for quarterly sales data for a company.
18. (18:28) Summary
19. (18:54) Conclusion and Video Links

What is difference between PERCENTILE.EXC and PERCENTILE.INC functions?

What is difference between QUARTILE.EXC and QUARTILE.INC functions?