Creating a Boxplot in Excel 2016

This video demonstrates how to create a boxplot (box and whisker chart) using Microsoft Excel 2016. Boxplots are used to analyze the distribution of scores in variables.

[@chrisdab-]

Going from excel tutorials to diagnosing serial killers in 6 years, and picking up almost 1 million subscribers along the way. Great job Dr. Grande.👋

[@WILLLLLLLLLLLLLLLLLU]

This is the #1 serial killer psychoanalysis and excel tutorial channel on KZbin

[@mikemhz]

Omg, Dr Grande! I can't believe I'm learning the box and whisker plot in Excel from Dr Grande himself.

[@laurenquiros2924]

I honestly can't thank you enough for this simple yet very effective and NECESSARY video!!!!! Keep em coming!

[@te.a9682]

The simplest box plot explanation I have seen in my life. Thanks Dr Grande

[@lizconnor1820]

I've only ever created a boxplot manually and it can be very time consuming. This video has been really helpful in demonstrating how to perform the same function, only faster and with less errors. This will be really useful in the future.

[@lindabecker1288]

You just turned my world around Todd - thank you.

[@soic9690]

This video helped a lot, Business statistics has been kicking me around so far.

[@jessicakabelwelter2774]

I’m not alone. Ugh. Thank goodness.

[@hammishreiske9916]

One of the best tutorials I have ever seen. Thanks champ

[@somikordafshari5121]

it was really fantastic, I completely understood and right after that I drew my Boxplot easily , thanks so much Todd

[@DrGrande]

You are quite welcome -

[@jonathanstupidcheesespaghetti]

GPA lifesaver. I appreciate your contribution to the digital world.

[@diamondstrouble]

WOW !! Thank you so much ! I have watched so many videos and none have explained in great detail like you did! You really helped me grasp this concept well!

[@lizziemuss616]

THE BEST boxplot tutorial, hands down!! You're saving my life over here

[@Vishal006]

For those wondering how to add axis titles for a box plot, heres how you do it: For horizontal axis just change the chart design to style 5 so it includes the x-axis titles. For vertical axis just go to chart design, add chart element, and add a y-axis title. Cheers.

[@sarahburrous7374]

Great explanation on box plots and how to create them in Excel. I did not understand how to interpret them previously. The IQR and understanding outliers was especially helpful.

[@suzgen7323]

This video was very helpful in creating a box plot. Also, calculating the variables effectively explained the outliers for both columns.

[@Cuchulainn42]

Thank-you Dr Grande, I am not doing very well in my class. Your tutorial was easy to understand and I was able to create a template for later usage. Again Thank-you.

[@phantompaper]

i came to find out how to create box plots in excel and realized your voice sounded familiar. Then i realized i watched alot of your videos on your case analysis, so thats cool.

[@akinyiaiko]

Very helpful, I found this very quite easy to understand although I had fears at the beginning. Thank you so much!

[@sarahm3767]

So my friend borrowed my KZbin app to look up an excel tutorial and I’m listening in the background like “wow this guy sounds JUST like dr grande” and I look and of course it’s you! Too funny, didn’t realize you used to do excel tutorials!

[@catramax]

Thank you for your simple, and effective explanation of this process. I appreciate this

[@amandachaffin6636]

This video was helpful to create a boxplot in Excel, it is nice to be able to use both SPSS and Excel for this chart. This is an easy way to establish any outliers that may occur.

[@vincentfelicianojr.9696]

Thank you so much. You instructions were so easy to follow and this is helping me a great deal in completing my stats finals project (Nyke shoe company).

[@Julia-pf2no]

A true lifesaver! Thank you for your video

[@delanguus]

Thanks for the very useful and clear explanation! As a non-statistics-guy, I only have one question left; why would one choose for the option "Including Median" or "Excluding Median", and what is the difference? Or in which case should I use "Including Median" and in which case "Excluding"?

[@mahditahamtan9337]

Thank you Dr. Grande. Your videos are amazing. Keep going

[@marmed2517]

Thank you so much this was very helpful! Is there a way I can make the boxplots horizontal?

[@blackdarck177]

dude i love you

[@tomaswilhelmsson5621]

exactly what I needed! Thanks!

[@behzaddastjerdy6799]

Really informative. Thanks Todd!

[@genesiss7359]

You saved my life. A thank you is not enough!!

[@LauraTeAhoWhite]

Dr. Grande just wants to remind you he isn't diagnosing anyone, only speculating about what could be happening in EXCEL.

[@ARWA8400]

so helpful so simple so perfect! thank you

[@l_t_truth_seeker]

Thank you so much Dr. Todd! Please keep it up with the good lessons.

[@TheMisterman15]

This helped with my data assignment, thanks.

[@lucylixiang]

Thank you so much! I literally don't know how to use excel properly but this tutorial helped me with my report :)

[@minamiisufii6809]

Thank you so much for this video Dr. Todd.

[@johnstone4873]

Thank you for this one, was really helpful, you don't perhaps have something on creating a geographic chart with data on excel, thanks

[@carlosdomingues3551]

I thought this voice was familiar! Thanks Dr. Grande

[@ChristopherSalisburySalz]

Awesome! I never really knew how to interpret a chart like this.

[@tom-mb7jd]

Thank you, just what I needed!

[@DrGrande]

You're welcome!

[@whyIeo]

bruh i wish my teachers were this good at teaching, i learn more off youtube than in class lol

[@rachelkong8247]

Thanks so much for the tutorial. It is very clear and very helpful for me. Really appreciate it. Thanks

[@renemaier5197]

Still relevant and amazingly easy!! Thank you

[@certainperfectratio]

Excellent, thanks. Excel doesn't describe outlier definition in their documentation, so this is much appreciated.

[@DrGrande]

You're welcome, thank you for watching -

[@funzoneeeee]

Extremely Helpful

[@SgtPeppersLonelyHeartsClubBand]

Wow, you honestly freaked it with this tutorial. Incredible accuracy, no need to waste time looking up other videos. Can I give you like 5 subs?

[@taniavonvisger113]

Dr. Grande - thank you so much for all of your you tube presentations. Very clear and easy to understand. I have 12 data points over 6-week period to show on one graph (6 before weekly intervention assessment and 6 after weekly intervention assessment). How do I do this in Excel 2016?

[@liyanaz9922]

hello, I only have three sets of data, (triplicate readings), can i still use this to check outliers?

[@putradaninla-aesong7758]

Thx so much sir, it's very helpful.

[@deltatrends7962]

Well explained. Thank you.

[@Margaret_rose_ellis]

This is really helpful. Some advice - please zoom in when doing functions. :)

[@TheMoustruo99]

Awesome video, thanks.

[@danihlzita2345]

Hello. Perfect video, helped me a lot. Although I have a question. What's the statistical/mathematical terminology for the transformation of each variable when fixing the outlier issue? Thank you.

[@kristinagrozic2526]

Fantastic explanation, thank you so much!

[@gaganjain1988]

Well Explain. Thanks Todd.

[@daluadavi]

Thanks for the explain....

[@carlosvillavicencio9380]

Thank you very much. Didnt know it´s already included in excel 2016. Also thanks for the ouliers explanation, I was wondering just where did it came from. I suppose the graphics options allow us to include the critical values in the chart. I´ll keep digging.

[@vasubisai7637]

well explained about box plot in excel

[@brandonbodine9860]

Thank you, You made doing this easier than Minitab.

[@DrGrande]

I'm glad you found the video useful. Thanks for watching.

[@NeverbackdownplayzYT]

Hi Todd, Thank you for the wonderful video. I am applying this to my data and getting lowe outliers in the negative, which do not relate to the whisker this is because my IQR*1.5 value is becoming more than Q1 and similarly upper outlier cutoff also is a bit different (i.e. higher) the whisker top head. I checked the formulas, not sure why this is happening! thanks

[@gabranis4741]

This helped me a lot. Thank you!

[@alessandrastellacaporale5256]

I really love the way you explained how to create a box and whisker plot in Excel. Very clear and straight to the point, and you provided all the needed information to understand not just the steps to make, but also the math behind them! Thank you!!

[@ahmadosman4862]

THANKS A LOT!!!! Really appreciate your work.....

[@DrGrande]

You're welcome - thanks for watching.

[@johnsharpe4809]

THANK YOU SO MUCH!!!!!

[@AJ-et3vf]

Awesome video. Thank you

[@cassieperoulis4881]

At first box plots were rather confusing for me, but this video helped explain the steps in which they are used for.

[@HanySalem]

Thank you. Can we use the calculated data instead of the raw data to have the box plot?

[@zs5874]

Amazing and useful video! thank you

[@sushmitasingh6298]

Thank you so much!! This video was very helpful for me!! 🤗

[@vasanthawadasriramanasaket9933]

Life saver!!!!

[@buffhotchkiss7400]

Thanks for your help

[@Andre..S..]

Thank you Dr. Todd!

[@DrGrande]

You're welcome!

[@rachelporter8328]

So helpful, thank you!

[@buffalosabres616161]

Great stuff - thanks a lot for the help!

[@DrGrande]

You are quite welcome -

[@phyrath5]

For anyone who's just needs to know where the Boxplot is: 5:40 Dr. Grande goes over a lot of set up for doing things with boxplots in the first five minutes but if you're just looking for an easy visual confirmation of weather or not there's outliers in your data you're shown where the boxplot is at the timestamp provided above.

[@Tetrium]

Is it possible that Excel 2016 on Mac does not have Statistics Charts? I've been looking at all the charts in the Insert menu and can't find it...

[@smashpanda]

I've been having the same problem

[@toniklemm1172]

I think so. I have Excel 2016 for Mac, too, and I can't find it either :-(

[@tschannel7111]

they are definitely not there! I split my hard drive and have Windows 10 where I can run all of the charts. That would be the best thing to do. There are certain accessories that are not accessible on word, as well, on Mac

[@zoyegilliland8452]

It seems like that is something that should have been mentioned ugh thanks for the info I will stop looking

[@toqamanasarah4462]

it is now available in the recent update

[@petercheng2322]

but how to add the X axis label to this box plot?

[@hannahtee3164]

is it possible if you could demonstrate outliers with the standard deviation method.

[@wegonah]

Thank you Dr Todd Grande. I have just completed my box and whisker chat for a single variable. How do I contact you to ask a direct question regarding interpreting my chat?

[@lanhnguyenthi2069]

Thank you so much for your Video! It's very useful. I hope that you will generate more useful videos like this one.

[@DrGrande]

You're welcome!

[@turtletazzy8737]

Very helpful, thanks!

[@DrGrande]

You're welcome - thank you for watching.

[@abhyni]

Thank you. This was very helpful :)

[@izakmiklavcic8243]

Thanks man, really helpful

[@DrGrande]

You're welcome. Thanks for watching.

[@SnotRockets55]

Thank You, Sir!

[@DrGrande]

You're welcome!

[@bykuldeep7013]

thanks a lot for this awesome video

[@vincentfelicianojr.9696]

Do you have a video on how to make the boxplot horizontally?

[@MorfinMaria3]

Could you incorporate a dotplot with these box and whisker plots? Along with standard deviation?

[@username42]

so what is the standard deviation for this data set, is it the values difference between the top and bottom fo the whiskers ?

[@sindaldorri1071]

thank you very much for your clear explination

[@zeynepazar8056]

when I create a box plot and thick the option 'mean marker', excel marks the mean on the plots with an 'X'. I want to change this mark, make it dashed line for example. But I could not find any option to change the marker. Do you know how I can do that? or is it possible to show the man with the line but not the median? Thanks

[@dougwright4542]

Dr. Grande doing Excel Statistical Graph Tutorials (ESGT-Grande) is the new FDA Standard Quaalude Equivalency (SQE). *said w/love*

[@birdworldist]

Yesss king go off

[@simonedejonge634]

what is the difference between inclusive and exclusive?

[@kirasmith1116]

How do I create a plot with different x-values instead of just the "1" that shows up?

[@AT-nm4dn]

同样问题

[@jerrardliu1324]

@@AT-nm4dn same

[@catarinaesteves3]

Is it possible that the oulier is a negative value?? or when i calculating the lower outlier i should add the abs() tool, in orden to give me the absolute number (without the signal) ?? Help plssss

[@StateOfTheArt]

Thank You!

[@DrGrande]

You're welcome.

[@aliibrahimali3113]

Nice one Todd 👍🏽👍🏽

[@DrGrande]

Thank you!

[@letagobosho1313]

very helpful thank you very much

[@Retrosenescent]

But was the box plot abused as a child?