Quick question - why does Excel produce decimals when calculating with percentile.inc? Let’s say I have a data set of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. The 90th percentile is 9. When I input the same data set in excel and use the percentile.inc function, it says the 90th percentile is 9.1.
@@Computergaga Thank you! I'm in a Research Methods class and some of the data sets are hundreds of rows long and so this will save some time instead of having to scroll down to the bottom.
your voice reminds me of the guy that is from Australia and hunts for dangerous sea creatures on the discovery channel. Really random but funny lol!
Sounds like a cool dude. I'm definitely not hunting sea creatures 😜
fantastic accent
Thanks :)
Good day, can you please explain the formula to calculate the 70th and 80th percentile if you have the 50th, 75th and 90th? salary
Much obliged Mr. Arthur Shelby
My pleasure 😊
THIS JUST SAVED MY LIFE!! Greatly appreciative. #IPEDS
Excellent! My pleasure.
I want you to stay here, and make sure that he doesn't leave!
You are my savior!!!
😊
i love you
thank you so much
You're welcome. The love is much appreciated.
Thank you!
You're welcome, Nadia.
Thanks for your help!
You're very welcome.
thank you big help :)
You're welcome! Great to hear!
Quick question - why does Excel produce decimals when calculating with percentile.inc? Let’s say I have a data set of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. The 90th percentile is 9. When I input the same data set in excel and use the percentile.inc function, it says the 90th percentile is 9.1.
I am having the same issue, have you figured it out?
@@scaredbear1503 Include "0" in your array to get 9.
thanks!
You're welcome, Ben.
Thank you 😊
You're welcome 👍
So would you interpret this as 90% of students got a score of 91 or lower and 25% of students got a score of 53 or lower ?
that's correct
Yes correct!
How does he quickly select all the data in the column at 1:43? There must be some sort of key shortcut that I really want to know.
I used the Ctrl + Shift and down arrow combination for that.
@@Computergaga Thank you! I'm in a Research Methods class and some of the data sets are hundreds of rows long and so this will save some time instead of having to scroll down to the bottom.
@@JJ_in_Raleigh Ah yes, indeed. No worries, Jeramiah.
it keeps giving me 0. Why is that?
Yes.
👍
This has changed
?
you should learn a different accent
Charming!
bored video
The guy is doing a favor to us to make available this video, and you are expressing unnecessary rudeness. Be appreciative.