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 : www.youtu.be/B...
Download worksheet here: drive.google.c...

[@drrodrigoromanpena3742]

Excellent video! Finally I found somebody who can explain how to do a box whisker manually. This is important because that is why you need to do if you want to make a box whisker using class data as it is my case. Thank you!

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

[@NewEdit617]

Thank you! I could not get the built-in Box-And-Whiskers function to do what I wanted, but your video demonstrated perfectly how to create the type of graph I wanted.

[@joshemman]

Glad the old video still helps. Thanks for dropping a note.

[@neelsrv]

@@joshemmanI am still referring your video ❤

[@joshemman]

@@neelsrv Thank you! 🙏

[@marcjackson9571]

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

[@bernicemain2647]

This was extremely helpful! Thank you very much ; )

[@yourmomsaidhi]

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

[@brandonhowes5364]

Thanks, helped on one of my Statistics Assignments.

[@tashanipiyushani5348]

It is very greatful to me

[@trisahchristina1811]

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

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

[@cabrinieconstantine3597]

omg u saved me a bunch! thanks

[@AJ-et3vf]

Great video. Thank you

[@Joe-fi5kf]

Thanks man, this was very helpful!

[@josephodoyo5981]

Very Helpful

[@deddywirata3719]

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

[@HighAngel]

Nice! THX man :)

[@karahrahmii2499]

Cool and helpful, thanks

[@Shubham.daliya]

There is no plus option in new excel

[@joshemman]

Which Excel (year) are you referring to?

[@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: czcams.com/video/5QgctkvP4Gs/video.html

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

[@abns4792]

Thnx

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