Properly Calculate Percentile and Percentile RANK in Excel (INC vs EXC)

Confused about percentiles and percentages? 🤔 This enlightening video unravels the mystery, making these concepts crystal clear, especially for those new to Excel or non-native English speakers.

🌟 Highlights:
▪️ Understanding Percentiles: Grasp what it means for your salary or test scores to be in a certain percentile.
▪️ Distinguishing Percentile from Percentage: Clear, concise explanations of these often-mixed-up terms.
▪️ Excel Percentile Functions Simplified: A user-friendly walkthrough on PERCENTILE.INC and PERCENTILE.EXC in Excel.
▪️ Real-World Applications: Learn through practical examples - ideal for analyzing salaries and interpreting test results.
▪️ Excel Skills Upgraded: Explore essential Excel functions that are valuable across various professions.

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.

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

🎬 LINKS to related videos:

🚩Let’s connect on social:

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!

#excel

[mcd]

I just ran some calculations. It turns out my love for this channel is 100%.

[simonkirkness]

That was very useful..as someone who is studying project management I’m always looking at your your YouTube videos for help to solve a problem or for something I know Excel can do but have no idea how to do it …. Thanks for all your great content 👍

[sternritter]

This was really helpful! Never stop making videos! You have no idea how many people you've helped!

[HeatherMajors]

Thank you for the clear explanation of the functions and how inclusive and exclusive are different.

[michaelsanders]

Great never realized the subtle differences between percentage and percentile. And my regular pitch for you to do an ASMR channel; I love your voice!

[DemetriPanici]

This is a really useful funciton! Thanks for the tips Leila!

[sajeens]

Thank you Leila for this...once again... very helpful 👍🏼

[anillpatel]

I learn something new every time I watch one of your video presentations...,
Thank you Leila.

[williamrivera]

Good video, well explained and clear to understand. Thank you.

[Kim-mpwg]

thank you! this video is so helpful and is really good at explaining the uses/differences in percentile functions for Excel :)

[tlyzjst]

You Leila are an incredible teacher. Thank you.

[cchan]

You are single-handing solving millions of people problems

[westernugmedia.]

Thanks my Lecturer ever, always Ugandan watching u ever🌹

[tifouraamina]

Love you Leila, I always learn something new with you ❤❤❤❤

[Rajiblayek]

you are supeeeer !! So simply explained . great job.

[mark]

This is terrific. I wish I had learned this stuff when I was in school, but better late than never.

[shadrackawunyo]

Very beautiful presentation Leila. You are always at the peak of your game. Very useful video for my use.

[yulinliu]

Thanks Leila. I would say that the exc formulas are theoretically more correct but the Inc formulas are practically easier to use. They return very close results for larger data sets.

[imabdulmannan]

Thank You I learned a lot. Always you come up with something different ☺️

[master_jk]

I also follow your YouTube channel. It has very grateful and useful video to study to us. Thanks
Good luck