You can donate small amount to show your appreciation to my help by clicking on this link: paypal.me/excelmaths Thank you for viewing my videos and supporting my channel! Regards Bob
You explanation was great. As a suggestion, maybe include a scenario when you would use exc vs inc. Real life examples always work best. Thanks for the video!
@@eXcelMathS Lol, that doesn't answer the question. I can't find anyone who can explain when I would use the exclusive vs. inclusive, or what advantage/disadvantage either have.
@@Dartheomus you can use percentile.exc when you do not want to count the "exact value" of MIN and MAX to your dataset. Imagine, you are a teacher and you have 30 students in your class. They wrote a test and got some points. Due to their points you want to make a scale to give them a grade, but you do not want to count the best and the worst to the count, because it will significantly change the layout of points and therefore it will change the grades for students. Sorry for my english - I did my best (btw - I use also percentile.inc all the time, this is the answer I got from my professor).
@@Dartheomus ruclips.net/video/VP5rYHlMys8/видео.html&ab_channel=FastStatisticsUsingExcel I hope it will help you a little. The difference is that the exclusive version takes into consideration 99 percentiles (P1 until P99) while the inclusive version takes into consideration 101 (P0 until P100)
Hi Bob Unfortunately your video doesn’t explain WHY they are different. Obviously designed for difference uses/circumstances/objectives but you don’t explain this and yet it is the most important issue to address!
ruclips.net/video/VP5rYHlMys8/видео.html&ab_channel=FastStatisticsUsingExcel I hope it will help you a little. The difference is that the exclusive version takes into consideration 99 percentiles (P1 until P99) while the inclusive version takes into consideration 101 (P0 until P100)
You can donate small amount to show your appreciation to my help by clicking on this link: paypal.me/excelmaths
Thank you for viewing my videos and supporting my channel!
Regards
Bob
You explanation was great. As a suggestion, maybe include a scenario when you would use exc vs inc. Real life examples always work best. Thanks for the video!
Thank you, very nice video!
Maybe you could add a column of percentiles instead of changing the cell formula one by one. That would be very tedious.
He does have that. He just needs to reference that column (maybe change it to decimal format) and bring the entire formula down.
What do you mean when you say the result of the function lies between "two values?"
thanks
Okay that's the difference but what's the significance of .EXC??
It is a good question! Normally i would use percentile.inc to find the values at a particular percentile. I don't use percentile.exc at all
@@eXcelMathS Lol, that doesn't answer the question. I can't find anyone who can explain when I would use the exclusive vs. inclusive, or what advantage/disadvantage either have.
@@Dartheomus you can use percentile.exc when you do not want to count the "exact value" of MIN and MAX to your dataset. Imagine, you are a teacher and you have 30 students in your class. They wrote a test and got some points. Due to their points you want to make a scale to give them a grade, but you do not want to count the best and the worst to the count, because it will significantly change the layout of points and therefore it will change the grades for students.
Sorry for my english - I did my best (btw - I use also percentile.inc all the time, this is the answer I got from my professor).
@@janbratt1470 But in this example (Above Video), he has taken all data points from 0 to 30 and have considered them as 80% and 30% respectively.
@@Dartheomus ruclips.net/video/VP5rYHlMys8/видео.html&ab_channel=FastStatisticsUsingExcel
I hope it will help you a little. The difference is that the exclusive version takes into consideration 99 percentiles (P1 until P99) while the inclusive version takes into consideration 101 (P0 until P100)
Hi Bob
Unfortunately your video doesn’t explain WHY they are different. Obviously designed for difference uses/circumstances/objectives but you don’t explain this and yet it is the most important issue to address!
no help
this does not explain why the functions are different. it just shows the result. not useful.
ruclips.net/video/VP5rYHlMys8/видео.html&ab_channel=FastStatisticsUsingExcel
I hope it will help you a little. The difference is that the exclusive version takes into consideration 99 percentiles (P1 until P99) while the inclusive version takes into consideration 101 (P0 until P100)
Poor explanation.
I hope it will help you:
ruclips.net/video/VP5rYHlMys8/видео.html&ab_channel=FastStatisticsUsingExcel