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!!!

[@jadeross9333]

Thank you so much, this really helped me :)

[@brianmchaney7473]

I would like this TWICE if I could.

[@MinhPDX]

You saved my life.

[@halonreverse]

Thanks a ton for this video, highly appreciated.

[@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

[@mapi77]

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

[@cometissandier7042]

Thanks a lot for yours clear explanations!

[@elenahg]

Thank you for the clear explanation.

[@likandoluywa3973]

wonderful and easy expaination

[@kelsstizzle2]

TY

[@danaalbright117]

Thanks for the help

[@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

[@Squiderrant]

Thankyou, very helpful tut

[@pilleriinvarv9918]

Thank you!

[@PriyankaSingh-ye7su]

Thank u sooo much

[@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.

[@ranakhanom]

thanks it was great

[@sobrsobe9566]

thank you

[@ryanlong1]

Thank you!!!!!

[@itsnotmeitsyou4582]

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

[@BS-kh4rf]

How do you get the 1.5 to multiply?

[@musicislife665]

Theanks

[@jihatenexon5219]

How did you get the 1.5?

[@moogunsanya7984]

You rock :-)