I was thinking exactly the same thing! If all of the scores in the data set are integers, then the quartiles can only be either an integer or a value halfway between two integers, which would be a number ending in .5, yet this video calculates a value ending in .75 WTF??? How does Excel calculate quartiles, and why is it different to every high school maths textbook I've ever used? Excel has some fantastic tools for visualising data at the high school student level, and I love incorporating it into my classes to make stats a little less dry a topic, but if I can't reconcile the quartiles produced by Excel and those my students calculate themselves using the techniques taught in every maths textbook for the last century, I will have no choice but to tell my students not to rely on the calculated values that Excel gives them.
Very informative and simplified. The explanation and walk through was clear. Thank you.
You tutorial is Great. Keep up the good work
AWESOME! Thanks for making these vids!
Awesome!Thanks! That's so good explained
thank you so so so so much. saved me hours.
Where does the Excel team go to drink after a long day? At the formula bar
😂😂😂
i like this video has help me, thanks
You're awesome!
very well explained !
Very helpful video
Very helpful
Definitely need more training
Where did the 25% come from? I followed along other than that! :)
In this video 5:03 min (4 quartile = 100%; 1 quartile = 25%)
my excel says this function is only allowed for excel 2007 users...
HI, can anyone explain what is quartile to me? Thank you very much
Hello, I prepared the following video explaining quartiles. Thank you very much for watching.
And 3 years later they still don't have this function for Pivot Tables.
I m the First who Comment here
Hi, I'm Yaseer Azam. I'm a Deaf. Please send me for pdf
n+20/4 = 21/4 = 5.25 , item 5 and 6. is 68 and 73, how to get 71.75? Dont you all realised that Excel Quartile formula is not correct?
I was thinking exactly the same thing! If all of the scores in the data set are integers, then the quartiles can only be either an integer or a value halfway between two integers, which would be a number ending in .5, yet this video calculates a value ending in .75
WTF???
How does Excel calculate quartiles, and why is it different to every high school maths textbook I've ever used? Excel has some fantastic tools for visualising data at the high school student level, and I love incorporating it into my classes to make stats a little less dry a topic, but if I can't reconcile the quartiles produced by Excel and those my students calculate themselves using the techniques taught in every maths textbook for the last century, I will have no choice but to tell my students not to rely on the calculated values that Excel gives them.
@@bradhilton4838 after 3 years at last someone staty to realised this.
Aaj mera birthday h mujhe gift me 1 subscribe de