The Excel Quartile Function

Learn how to use the Excel quartile function to quickly calculate the four quartile numbers of any range of data. ***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa... See my entire playlist of Excel videos: bit.ly/tech4excel Here is the practice file that goes with this video: bit.ly/excelquartile #excel #exceltutorial

[@cogwheelLearning]

Where does the Excel team go to drink after a long day? At the formula bar

[@ReprintifyAcademy]

You tutorial is Great. Keep up the good work

[@blissmint]

AWESOME! Thanks for making these vids!

[@veramaslova5764]

Awesome!Thanks! That's so good explained

[@moniruzzamanmishu279]

very well explained !

[@PemberiSolusi]

i like this video has help me, thanks

[@chhotanbiswas7387]

Very helpful video

[@AoT_isLife]

thank you so so so so much. saved me hours.

[@sukanyalodh9810]

Very helpful

[@gyiselhernandez6580]

You're awesome!

[@LinkFanatic]

Where did the 25% come from? I followed along other than that! :)

[@jessicacabrera199]

Definitely need more training

[@interstellar0001]

my excel says this function is only allowed for excel 2007 users...

[@wenbintan2676]

HI, can anyone explain what is quartile to me? Thank you very much

[@faststatisticsusingexcel7022]

Hello, I prepared the following video explaining quartiles. Thank you very much for watching.

[@parkinglotpatty2911]

And 3 years later they still don't have this function for Pivot Tables.

[@cit-civilinnovationsandtec9541]

I m the First who Comment here

[@yaseerazam307]

Hi, I'm Yaseer Azam. I'm a Deaf. Please send me for pdf

[@andrewwoo2902]

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?

[@bradhilton4838]

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.

[@andrewwoo2902]

@@bradhilton4838 after 3 years at last someone staty to realised this.

[@djrajutigriya3819]

Aaj mera birthday h mujhe gift me 1 subscribe de