Excel Statistical Analysis 12: Percentile, Quartile, Percentile Rank and Rank Functions & Algorithms

Video Description

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?