How To Find Quartiles and Construct a Boxplot in Excel

This short tutorial shows how to use Microsoft Excel to correctly construct a horizontal box plot.
If you want a vertical bar chart, select a stacked column chart.
Boxplot inbuilt in Excel: • Boxplots in Excel | Si...
Horizontal boxplot : ua-cam.com/video/BRAj_kZXRjg/v-deo.html
Download worksheet here: drive.google.com/file/d/0B6Yg...

[@TheMixingBowlHomestead]

Where have you been all my STAT200 life? Books make it so complicated and I have been crying my eyes out. Thank you... this is a huge help to help me understand how to calculate Min, Max, and interquartiles

[@anggitawirahma]

Finally i found the long method to make bos whisker!!! Thank you!!!!!

[@bernicemain2647]

This was extremely helpful! Thank you very much ; )

[@yourmomsaidhi]

SO HELPFUL, CLEAR & EASY TO UNDERSTAND !!! thanksssss just saved me in statssssss

[@marcjackson9571]

You really know what you're doing!! Thank you!!

[@Joe-fi5kf]

Thanks man, this was very helpful!

[@brandonhowes5364]

Thanks, helped on one of my Statistics Assignments.

[@AJ-et3vf]

Great video. Thank you

[@karahrahmii2499]

Cool and helpful, thanks

[@cabrinieconstantine3597]

omg u saved me a bunch! thanks

[@josephodoyo5981]

Very Helpful

[@trisahchristina1811]

Hi what is the difference between inclusive and exclusive? Should I calculate percentiles using exclusive or inclusive?

[@tashanipiyushani5348]

It is very greatful to me

[@deddywirata3719]

Thanks, luckly excel understands our problem and they introduced the box plot feature in excel 2016

[@HighAngel]

Nice! THX man :)

[@williama.rivera9414]

Good video and information Mr. Joshua, one question. I saw that the numbers or data set is not in ascending order; is not a matter in obtain the quartiles results? Thank you for teaching

[@joshemman]

If you're doing manual calculations, the order matters. But with software, you don't have to bother. The software takes care of that.

[@williama.rivera9414]

@@joshemman Thank you so much for answer.

[@Sulegibongtoo176]

what if you want to have 2 boxplots? when i go to put in the error bars it puts the same error bars on both boxplots as opposed to different ones on different boxes.

[@joshemman]

Excel in Office 2019 now has a boxplot chart. Just highlight the two data sets, go to Insert and select the boxplot option (under histogram icon).

[@olygrl01]

Is there anyway to duplicate this in google sheets? The part I cant figure out is the error lines

[@joshemman]

I haven't tried it in Google Sheets but this video might help: ua-cam.com/video/5QgctkvP4Gs/v-deo.html

[@abns4792]

Thnx

[@Shubham.daliya]

There is no plus option in new excel

[@joshemman]

Which Excel (year) are you referring to?

[@adiyabilguun5063]

why calculate diff ? tell me pls

[@joshemman]

It's a workaround.
Excel now has the capability of creating a boxplot so you don't have to use this approach.

[@khairolnajmi]

I LITERALLY UNDERSTAND NOTHING!!!!!

[@joshemman]

Oh sorry😔. What exactly are you looking for?