This video shows how to calculate percentiles/quartiles/deciles using the locator formula (Lp=(n+1)p/100) and also in Excel.
Пікірлер: 144
@ligy303 жыл бұрын
Finally a tutorial that finds a percentile that's not 20 or 80 or something. This explains it perfectly! thank you!
@ArehPraise3 ай бұрын
Hi
@TictacmanJr5 жыл бұрын
The only tutorial I found which explained it perfectly.
@anycatdessai4 жыл бұрын
True.
@user-jz6ty4ob7o3 жыл бұрын
附议
@francaconnell-stubbs66783 жыл бұрын
Joshua After two days of watching KZbin videos, your explanation was in a way that is so easy to understand. Thank you. 🙏
@domingovaca24106 жыл бұрын
THis is not only explaining the basics but also explaining the complex part of the decimals in a percentile! Loving it! Thank you Sir!
@ankitgupta91546 жыл бұрын
man the humanity lies in your hand truly.. 😭 You should be the Education Minister of my Nation 😭 Thank you a loads..
@ABDULRAHMAN-yk9jv3 жыл бұрын
YOU ARE GENIUS. BEST EXPLAIN EVER, YOU MADE MY LIFE EASIER BRO!
@naomiperez74826 жыл бұрын
I've never seen this anywhere else explained really well like you did... best English sentence ever.
@thatswhatshesaidbro6 жыл бұрын
Thanks dude this was the best video i found on youtube explaining percentiles in 1 minute !
@ghadaghada48815 жыл бұрын
I wish I knew you earlier...please more videos ...how genius u ARE
@selinashaw40454 жыл бұрын
It's very hard to explain this topic and i am very glad I found your video some professor do not go in-depth as your video thank you very much for this video. #2019
@caribbeanqueen13896 жыл бұрын
:) I love you! Lol... Why didn't my stats teacher just explain it like this all the time?!
@gamestar2094Ай бұрын
Totally direct and clear, such great math explanation video.😊 Thank you.
@a.c.n.94214 жыл бұрын
You are SOOOOO much better than my teacher, my book and other YT channels. THANK YOU!!!!
@cbellaq23172 жыл бұрын
You're brilliant!! Thank YOU for explaining it so perfectly!
@SukhwinderKaur-pn3is3 жыл бұрын
Thank you for explaining this in detail. This is really helpful for me.
@dianapena10124 жыл бұрын
Thank you so much! The only video that I found to be helpful.
@urielfloresnila6084 жыл бұрын
Thank you so much, this was the best explanation I've found!
@bandatron2 жыл бұрын
You are the best! Thank you!!! better than the textbook!!
@hafenihangula2270 Жыл бұрын
Amazing Tutor 🙏
@pampagrimaldi85842 жыл бұрын
great explanation Joshua!
@jenc48473 жыл бұрын
Thank you SO MUCH for your explanation - you are a life saver
@chief26323 жыл бұрын
The 2nd half where you add the decimal and multiply always tripped me up, thanks
@bennyesteban37333 жыл бұрын
Really helped me at my assignment,, thankss
@arvin23606 жыл бұрын
Thank you Sir, It really helps for my exam :) 2018
@nouaini3 жыл бұрын
Perfect! Thank you Joshua.
@shaileshgupta86832 жыл бұрын
Now it's very clear thanks sir
@vimalthanth11473 жыл бұрын
Amazing Explanation sir!!
@user-ee4cn7hm6k9 ай бұрын
Perfect! This is helpful.
@adityajoshi64224 ай бұрын
Best explaination of the topic. Thanks!
@sudharshanhp86782 жыл бұрын
What is the mathematical formula for PERCENTILE.INC() ? Note: The above video is for to understand PERCENTILE.EXC()
@zafarmahmood89923 жыл бұрын
It can calculate easily in MS Excel. You apply best of its concept
@mohammedbesseddikbelhaidas92643 жыл бұрын
Thanks alot for this useful video!, I would be grateful if you provide the source of this formula. Thank you again!
@josephmctaggart226 жыл бұрын
Excellent and concise explanation
@MrNoways78 жыл бұрын
thank you Sir this helped me a lot with the exams
@ruthl9854 Жыл бұрын
Thank you so much it’s really helpful for my assignment 😊
@zeeshanahmed259411 ай бұрын
Brilliant explanation of percentile. Thank you.
@joshemman11 ай бұрын
Glad it was helpful!
@semnijipa2649 Жыл бұрын
Awesome explanation. Thank you sir!
@joshemman Жыл бұрын
Most welcome!
@albertoflores14865 ай бұрын
Thank you friend, the video helped me so much
@joshemman5 ай бұрын
You're welcome, Alberto.
@sanjidaalam67474 жыл бұрын
Thank you so much! Explained beautifully
@judeLondon Жыл бұрын
Clear and what I was looking for 👌👌
@veerj60306 жыл бұрын
Nice and informative! Thanks joshua
@khomotsokgogome46935 жыл бұрын
Yassss ✊💃💃💃 This was very helpful. Thank you
@constanceosagie20053 ай бұрын
You nailed it,😅
@amani48513 жыл бұрын
You saved my life
@negusuworku2375 Жыл бұрын
Thank you bro very helpful
@HwanTu6 жыл бұрын
amazing. this is a great help. thank you sir! :D
@taladiv34152 жыл бұрын
Thank you for your explanation video.
@rickparamanik580 Жыл бұрын
very helpful👍
@user-uy7mt7vr6f3 жыл бұрын
Excellent lecture! Smooth slides! Amazingly well done, Joshua!
@zakariaekaputra84095 жыл бұрын
Wow, thanks a lot sir. But what if it's a collective data like 1-5, 6-10,... Do i have to look for the mid-point first...?
@joshemman5 жыл бұрын
That will depend on your textbook. Some do it that way, some don't.
@coffeeforbb730111 ай бұрын
Thank you for the informative question, one thing is unclear to me. I hope you can respond. If our L46 = 5.52, how come that we used the 5th value of 5.52 is closer to 6 if rounded off? thanks!
@joshemman11 ай бұрын
There are different approaches to percentiles. Some round, and others interpolate. We used interpolation in this video.
@andiiswah74613 жыл бұрын
This was very helpful👍😀
@rehabalsaleh1663 жыл бұрын
Perfect explanation!
@russman87072 жыл бұрын
You’re amazing
@jmarcmotovlog35615 жыл бұрын
Thank you this helped me a lot.
@SiTang6 жыл бұрын
Knowledge is great score!
@asashish905Ай бұрын
Suppose n=7 and I want to calculate p90 How is it gonna work? The formula give 7.2 I think to apply your formula, n>7 Please correct me if I am wrong.
@joshemmanАй бұрын
Using this formula, for n = 7, you will have to pick the maximum value as the 90th percentile.
@shubhammishr4 жыл бұрын
Thank you sir you are life saver
@BluSou111 ай бұрын
why is this completely different from my textbook? It says nothing about adding n + 1 it says to only multiply n(p/100) why is this the case?
@joshemman11 ай бұрын
Different textbooks use different approaches to calculate Percentiles. Stick to your textbook approach for success in your course.
@BluSou111 ай бұрын
@@joshemman thank you
@eggxecution6 ай бұрын
brilliant
@AriseGhana3 жыл бұрын
wow so easy to understand
@user-lk3tf7oi4y9 ай бұрын
Why does the formula for location have +1?
@joshemman9 ай бұрын
Different formulas are used to find this locator. Use the one your course adopts. These are simply different perspectives to percentiles.
@alidonhannaiahblests32805 ай бұрын
how do i make conclusion about the answer?
@Spunky_clare3 жыл бұрын
All I can say is WOOOOOOOW!!
@nidhitripathi50143 жыл бұрын
What'll be 20th and 80th percentile of series 5.50 , 4.70 , 3.20 . And How we can solve it on paper not on excel
@jonof14224 жыл бұрын
Helped heaps, thank you
@user-zi5is9yw2g5 ай бұрын
Thank you!
@Adrian-cn5rk3 жыл бұрын
How do we enter this in 1 step into a calculator though?
@alecgamer4202 жыл бұрын
Thanks !
@eska6722 Жыл бұрын
Thank you
@user-qq6xp2uw3t3 жыл бұрын
Hi would like to ask if its 95 percentile Lp would be more than 11, but it should be between 10 and 11, then how do we solve this
@joshemman3 жыл бұрын
Using this method, your 95th percentile will be the highest value if n = 11. Are you sure this is your formula?
@greengoblin6128 Жыл бұрын
In inclusive for eg in L46 it was 5.52 Her will we consider 5th observation?
@joshemman Жыл бұрын
Rephrase. Your question is unclear.
@greengoblin6128 Жыл бұрын
@@joshemman we used exclusive in excel.when do we use inclusive
@greengoblin6128 Жыл бұрын
@@joshemman ?
@joshemman Жыл бұрын
@@greengoblin6128 Inclusive means your percentile is included. For example, If 70 is the 60th percentile, then 70 is included as part of the bottom 60% as the upper boundary. If you used "exclusive", then 70 is excluded so that the bottom 60% are less than 70. It's the same difference between < and ≤.
@greengoblin6128 Жыл бұрын
@@joshemman thank you 👍👍
@rajkc49453 жыл бұрын
Thanks
@ahmedfaroukramadan98683 жыл бұрын
😊 thanks
@j.nguyen2948 Жыл бұрын
If we change data like this: 5 12 16 18 18 18 18 31 32 33 39, How can we calculate P46 ?
@joshemman Жыл бұрын
The Locator gives 5.98 position. Since both 5th and 6th values are 18, P46 is 18. or use 18 + 0.98(18 - 18)
@nidhitripathi50143 жыл бұрын
Please find 20th and 80th percentile of 5, 5 , 5.20 and please make video
@abhaygupta78785 жыл бұрын
Thank you so much sir
@user-vp6fr9nf1l3 жыл бұрын
لا إله إلا الله.
@Treant.3 жыл бұрын
Thank you very much! #2020
@indiancitizen19943 жыл бұрын
According to your calculated formula P90 gets more than data
@dsglife6 жыл бұрын
Bless you.
@PHOEBEE695 жыл бұрын
Wow thanks bro
@balamuralikannaiyan61643 жыл бұрын
I have a doubt. If there are 8 numbers and if I have to find the 90th percentile, I have to find the 8.1 th position (.9*9), which doesn't exist.
@joshemman3 жыл бұрын
Using this formula, for 8 values, the 90th percentile will be the highest value.
@balamuralikannaiyan61643 жыл бұрын
@@joshemman thanks a lot for the explanation and the video Sir! :)
@bogart78966 ай бұрын
How did you get the 46 and 100?
@joshemman6 ай бұрын
They are from the locator formula Lp. Since we are computing the 46th Percentile, p = 46.
@darlingtonodom69133 жыл бұрын
I used this method to look for the 40th percentile of 39, 29.4, 17 and 23 but the answer I got isn't even among the options
@joshemman3 жыл бұрын
There are many different approaches to finding percentiles. You'll have to check if the formula used in your course to find percentiles is the same as the one used here.
@narendrameena48623 жыл бұрын
What is means for 80 percentile
@mourishkumar13333 жыл бұрын
I love ur african accent
@tonytonychopper4655 жыл бұрын
Can you explain me why the 3rd quartile is the 75th percentile and also for the 9th decile?
@datboi18613 жыл бұрын
Percentiles divide data into 100 parts, quartiles divide data into 4 parts and deciles divide data into 10 parts. For quartiles, you have to count in batches of 25 to reach 100. So Q1 is 25, Q2 is 50, Q3 is 75 and Q4 is 100. For deciles, you have to count in batches of 10 to reach 100. So D1 is 10, D2 is 20, D3 is 30.... D9 is 90 and D10 is 100. For a better understanding of this, I advise that you watch The Organic Chemistry Tutor's video on this topic. It's explained in more detail there.
@thedarklierlier84402 жыл бұрын
@@datboi1861 thanks a lot
@datboi18612 жыл бұрын
@@thedarklierlier8440 No problem. Glad I could help in some way.
@thedarklierlier84402 жыл бұрын
@@datboi1861 you did pro thanks a lot
@xiergabrielm.mangunay55674 жыл бұрын
Thanks ma boi
@eric38595 жыл бұрын
why n+1?
@sreejx7 жыл бұрын
Hi Joshua,is there a formula in excel to calculate percentile of a score,for e.g considering above example as grades so out of 11 student if sum one scored 30 marks what is his percentile among other students.
@joshemman7 жыл бұрын
Could you please state the problem in full.
@sreejx7 жыл бұрын
consider these numbers 5,12,16,18,22,25,30,31,32,33,39 ,so if I want to find what is percentile of number 31 from the list ,how can I find it?
@joshemman7 жыл бұрын
Use =PERCENTRANK(array,31). Or if you guys use "Exclusive", then =PERCENTRANK.EXC(array,31).
@sreejx7 жыл бұрын
thanks Joshua for prompt reply.it works thanks a lot.
@hammadrehman18573 ай бұрын
Love this so much ❤😊
@pazey01 Жыл бұрын
Please how does he know that the 3rd quartile is 75th of the data
Can sum1 explain to me the quartile part I don't get it 😭😭😭😭😭
@rakeshnayak73604 ай бұрын
Then what is 75 percentile?
@joshemman4 ай бұрын
See 1:45
@faustinasam44152 жыл бұрын
The speed was too much...a much slower pace would have been better. I had to be pausing it and playing it over and over just to understand it.
@moeintaherkhani72893 жыл бұрын
With all due respect, but your formula is incorrect. I found out by trying to calculate the 99th percentile. try inserting n=11 and p=99, you'll find the index for the 99th percentile to be 11.88! That's greater than the last index (11). I think we should use 'n' instead of 'n+1'.
@greatnes3 жыл бұрын
There are more than 10 different formulas for calculating percentiles, depending on the context. For this formula, if the locator is greater than n, then the highest value is the percentile.