Properly Calculate Percentile and Percentile RANK in Excel (inc vs exc)

Learn the meaning of percentile in introductory statistics. I'll also show you how you can create meaningful percentile score calculations using the PERCENTILE.INC and PERCENTILE.EXC functions in Microsoft Excel.

You'll also learn how to use the PERCENTRANK.INC function in Excel to calculate the relative standing or the rank of a value within a data set as a percentage.

A percentile score describes the percentage of values below a certain point. When we describe percentile we use the word percentage. But they're 2 separate things and we'll cover the differences in the video.

00:00 What Does Percentile Mean?
00:52 Percentage vs. Percentile
01:28 How to Use PERCENTILE.INC in Excel
03:06 How to Use PERCENTRANK.INC in Excel
04:48 How to Use PERCENTILE.EXC in Excel
06:15 Wrap Up

🌍 My Online Excel Courses ► https://www.xelplus.com/courses/

⯆ DOWNLOAD the workbook here: https://www.xelplus.com/percentile-rank-calculation-excel/

🎬 LINKS to related videos:
Calculate Percentage Change in Excel: https://youtu.be/UN5PckRADyQ

🎒 Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

📚 Excel RESOURCES I Recommend: https://www.xelplus.com/resources/

🎥 GEAR I use: https://www.xelplus.com/resources/#gear

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel

Видео Properly Calculate Percentile and Percentile RANK in Excel (inc vs exc) канала Leila Gharani