Excel 2010 - Finding the Quartiles, IQR and Upper & Lower fences

[@alex_is_out]

Thank you so much for making this!! You explained it so much easier and simpler than any of my university lectures could

[@codytabbert]

Glad it was helpful!

[@teesmarie19]

Thank you so much!! My math project is a success because of you!! I'm in debt to you great sir

[@katielindsay8796]

You sir are a genius!!!!! This helped a lot!!!

[@halonreverse]

Thanks a ton for this video, highly appreciated.

[@jadeross9333]

Thank you so much, this really helped me :)

[@elenahg]

Thank you for the clear explanation.

[@mapi77]

Thank you so very much!!!! This was so helpful.

[@cometissandier7042]

Thanks a lot for yours clear explanations!

[@brianmchaney7473]

I would like this TWICE if I could.

[@MinhPDX]

You saved my life.

[@likandoluywa3973]

wonderful and easy expaination

[@Squiderrant]

Thankyou, very helpful tut

[@danaalbright117]

Thanks for the help

[@pilleriinvarv9918]

Thank you!

[@ryanlong1]

Thank you!!!!!

[@irfanvirji5319]

Lovely video. In my question however they've only said "what is the upper outlier if q3 is 61 and q1 is -24. How do you go about that? Thanks

[@ranakhanom]

thanks it was great

[@sobrsobe9566]

thank you

[@moogunsanya7984]

You rock :-)

[@kelsstizzle2]

TY

[@PriyankaSingh-ye7su]

Thank u sooo much

[@BS-kh4rf]

How do you get the 1.5 to multiply?

[@likandoluywa3973]

If you are analysing a set of data say salaries in a particular grade, what is the meaning of Q1, Q3 , IQR, upper and lower fences

[@musicislife665]

Theanks

[@jihatenexon5219]

How did you get the 1.5?

[@itsnotmeitsyou4582]

can't see how he chose the 1st quartile i can't do it!

[@thomasdo1125]

FYI, you are wrong in lower fence. lower fence can not be lower than the lowest number

[@codytabbert]

You're talking about drawing whiskers on a box plot. This is just how you find the lower and upper fence. I do not discuss outliers here nor the box plot. This is just the calculations of finding the upper and lower fence. If this video were to go further in depth and we discussed the box plot we would look at an example where there was an outlier and where there was no outlier and the whisker was drawn only to the lowest value. However none of that is discussed here. It's just showing you how to find the upper and lower fence mathematics using excel. I never said they were the whiskers of a box plot.

[@codytabbert]

I added a note at the end referencing what I said so that the user will understand that there is more to look at when proceeding to the box plot.