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.
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.
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!!
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.
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!
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.
So my friend borrowed my CZcams 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!
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.
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.
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"?
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.
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.
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.
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
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).
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?
Quick question Dr Grande, are you showing how to create a box plot in Excel or just speculating on how you could create a box plot in a program like this?
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
I've just realized that the whiskers do not correspond to minimum and maximum on my graph. Everything else is right though and i followed this tutorial word for word! any idea where i am going wrong or how i can change these?!
Dr Grande, the tutorial is great. I followed the steps properly, but for some reasons the boxplot contains neither boxes nor whiskers, just colored point (x) corresponding to given data in the spreadsheet. I went through the formatting options, but there is not one making me boxes... Any ideas to solve the issue?
How do we include outliers in the min/max of this graph so that the bars reach these points and take them in consideration in the calcul of the average?
write the outliers in a separate random cell for example write the outlier in the cell A5 and then in the minimum cell write QUARTILE.INC(A5,0) OR QUARTILE.INC(A5,2) KEY: 0 = minumim value, 2 = maximum value when calculating the average, replace the minimum and/or maximum value/s with The Outlier Value
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.
I dont get this you tell me to copy the data for the box plot, how is it referring to the five number Summary? I even chose inclusive median and they don't match Up?
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
This is the #1 serial killer psychoanalysis and excel tutorial channel on CZcams
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.👋
Omg, Dr Grande! I can't believe I'm learning the box and whisker plot in Excel from Dr Grande himself.
I honestly can't thank you enough for this simple yet very effective and NECESSARY video!!!!! Keep em coming!
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.
The simplest box plot explanation I have seen in my life. Thanks Dr Grande
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!!
This video helped a lot, Business statistics has been kicking me around so far.
I’m not alone. Ugh. Thank goodness.
One of the best tutorials I have ever seen. Thanks champ
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.
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!
it was really fantastic, I completely understood and right after that I drew my Boxplot easily , thanks so much Todd
You are quite welcome -
GPA lifesaver. I appreciate your contribution to the digital world.
THE BEST boxplot tutorial, hands down!! You're saving my life over here
You just turned my world around Todd - thank you.
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.
Thank you for your simple, and effective explanation of this process. I appreciate this
Very helpful, I found this very quite easy to understand although I had fears at the beginning. Thank you so much!
So my friend borrowed my CZcams 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!
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.
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.
A true lifesaver! Thank you for your video
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"?
Excellent, thanks. Excel doesn't describe outlier definition in their documentation, so this is much appreciated.
You're welcome, thank you for watching -
Dr. Grande just wants to remind you he isn't diagnosing anyone, only speculating about what could be happening in EXCEL.
This video was very helpful in creating a box plot. Also, calculating the variables effectively explained the outliers for both columns.
Thank you so much! I literally don't know how to use excel properly but this tutorial helped me with my report :)
Thank you Dr. Grande. Your videos are amazing. Keep going
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?
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.
Thank you so much Dr. Todd! Please keep it up with the good lessons.
You saved my life. A thank you is not enough!!
Really informative. Thanks Todd!
bruh i wish my teachers were this good at teaching, i learn more off youtube than in class lol
This is really helpful. Some advice - please zoom in when doing functions. :)
Thanks so much for the tutorial. It is very clear and very helpful for me. Really appreciate it. Thanks
I thought this voice was familiar! Thanks Dr. Grande
At first box plots were rather confusing for me, but this video helped explain the steps in which they are used for.
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.
Thank you so much this was very helpful! Is there a way I can make the boxplots horizontal?
Extremely Helpful
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.
Thank you,
You made doing this easier than Minitab.
I'm glad you found the video useful. Thanks for watching.
Awesome! I never really knew how to interpret a chart like this.
Just a reminder, he's not diagnosing the boxplots in this video, only speculating about what could be happening in an Excel situation like this.
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...
I've been having the same problem
I think so. I have Excel 2016 for Mac, too, and I can't find it either :-(
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
It seems like that is something that should have been mentioned ugh thanks for the info I will stop looking
it is now available in the recent update
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).
Awesome video. Thank you
Still relevant and amazingly easy!! Thank you
Thank you so much!! This video was very helpful for me!! 🤗
Thank you for this one, was really helpful, you don't perhaps have something on creating a geographic chart with data on excel, thanks
thanks a lot for this awesome video
Thank you. This was very helpful :)
Fantastic explanation, thank you so much!
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?
Thank you so much for your Video! It's very useful. I hope that you will generate more useful videos like this one.
You're welcome!
Dr. Grande doing Excel Statistical Graph Tutorials (ESGT-Grande) is the new FDA Standard Quaalude Equivalency (SQE). *said w/love*
Thank you. Can we use the calculated data instead of the raw data to have the box plot?
But was the box plot abused as a child?
so helpful so simple so perfect! thank you
This helped me a lot. Thank you!
tank you for teaching me how to use excel, i reely laik yoe
You're welcome!
very helpful thank you very much
Very well explained. thank you.
Quick question Dr Grande, are you showing how to create a box plot in Excel or just speculating on how you could create a box plot in a program like this?
Amazing and useful video! thank you
thank you very much for your clear explination
How do I create a plot with different x-values instead of just the "1" that shows up?
同样问题
@@AT-nm4dn same
Whoaah, i didnt think i would find a statistics tutorial from Dr. Grande lmao
This helped with my data assignment, thanks.
Awesome video, thanks.
what is the difference between inclusive and exclusive?
well explained about box plot in excel
The lower fences and upper fences created by the excel is not the same with the fences that I manually calculated. How can I change this?
Thx so much sir, it's very helpful.
So helpful, thank you!
Thank you very much indeed Sir
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
Calculating the IQR was a bit confusing, but I understand the concept of how the outliers are determined in this example.
THANK YOU SO MUCH!!!!!
THANKS A LOT!!!! Really appreciate your work.....
You're welcome - thanks for watching.
Thank you, just what I needed!
You're welcome!
I've just realized that the whiskers do not correspond to minimum and maximum on my graph. Everything else is right though and i followed this tutorial word for word! any idea where i am going wrong or how i can change these?!
Very helpful, thanks!
You're welcome - thank you for watching.
Dr Grande, the tutorial is great. I followed the steps properly, but for some reasons the boxplot contains neither boxes nor whiskers, just colored point (x) corresponding to given data in the spreadsheet. I went through the formatting options, but there is not one making me boxes... Any ideas to solve the issue?
ctr shift arrow selects all range until a space is found
How do we include outliers in the min/max of this graph so that the bars reach these points and take them in consideration in the calcul of the average?
write the outliers in a separate random cell for example write the outlier in the cell A5 and then in the minimum cell write QUARTILE.INC(A5,0) OR QUARTILE.INC(A5,2) KEY: 0 = minumim value, 2 = maximum value when calculating the average, replace the minimum and/or maximum value/s with The Outlier Value
Yesss king go off
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.
Thanks for your help
why you use E13*1.5? is it a formula? By the way, your video really teach me a lot than our professor!!! Thank you so much
Yes, is the formula for the outliers and quartil :)
can i use this method to determine outlier for three sets of data?, example 183, , 265 and 987, tq
What about negative values? I get bottom extreme negative, boxes and whiskers are positive.. the chart looks off
dude i love you
Thank you so much for this video Dr. Todd.
I dont get this you tell me to copy the data for the box plot, how is it referring to the five number Summary? I even chose inclusive median and they don't match Up?
Thank you.
Thank you Dr. Todd!
You're welcome!
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
Thanks for the explain....
Thank you very much!