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.
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!
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!!
So my friend borrowed my UA-cam 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.
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.
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.
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.
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.
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"?
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).
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.
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.
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
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?
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?
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.
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
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
This is the #1 serial killer psychoanalysis and excel tutorial channel on UA-cam
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!
The simplest box plot explanation I have seen in my life. Thanks Dr Grande
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.
One of the best tutorials I have ever seen. Thanks champ
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!
You just turned my world around Todd - thank you.
This video helped a lot, Business statistics has been kicking me around so far.
I’m not alone. Ugh. Thank goodness.
THE BEST boxplot tutorial, hands down!! You're saving my life over here
GPA lifesaver. I appreciate your contribution to the digital world.
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!!
it was really fantastic, I completely understood and right after that I drew my Boxplot easily , thanks so much Todd
You are quite welcome -
So my friend borrowed my UA-cam 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.
Thank you Dr. Grande. Your videos are amazing. Keep going
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.
Very helpful, I found this very quite easy to understand although I had fears at the beginning. Thank you so much!
A true lifesaver! Thank you for your video
You saved my life. A thank you is not enough!!
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.
Thank you for your simple, and effective explanation of this process. I appreciate this
Thank you so much! I literally don't know how to use excel properly but this tutorial helped me with my report :)
Really informative. Thanks Todd!
Thank you so much Dr. Todd! Please keep it up with the good lessons.
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 so much for the tutorial. It is very clear and very helpful for me. Really appreciate it. Thanks
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!! This video was very helpful for me!! 🤗
Excellent, thanks. Excel doesn't describe outlier definition in their documentation, so this is much appreciated.
You're welcome, thank you for watching -
Thank you,
You made doing this easier than Minitab.
I'm glad you found the video useful. Thanks for watching.
Fantastic explanation, thank you so much!
Thank you. This was very helpful :)
Still relevant and amazingly easy!! Thank you
I thought this voice was familiar! Thanks Dr. Grande
This helped me a lot. 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.
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.
Amazing and useful video! thank you
Awesome! I never really knew how to interpret a chart like this.
Very well explained. thank you.
so helpful so simple so perfect! thank you
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"?
But was the box plot abused as a child?
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!
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).
thanks a lot for this awesome video
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?
THANKS A LOT!!!! Really appreciate your work.....
You're welcome - thanks for watching.
So helpful, thank you!
Awesome video, thanks.
Extremely Helpful
This helped with my data assignment, thanks.
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.
Well explained. Thank you.
This is really helpful. Some advice - please zoom in when doing functions. :)
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 for your clear explination
what is the difference between inclusive and exclusive?
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
Thx so much sir, it's very helpful.
Thank you so much this was very helpful! Is there a way I can make the boxplots horizontal?
Whoaah, i didnt think i would find a statistics tutorial from Dr. Grande lmao
Thank you. Can we use the calculated data instead of the raw data to have the box plot?
Thank you so much for this video Dr. Todd.
Thank you, just what I needed!
You're welcome!
Very helpful, thanks!
You're welcome - thank you for watching.
Nice one Todd 👍🏽👍🏽
Thank you!
very helpful thank you very much
Thank you very much indeed Sir
Thank you for this one, was really helpful, you don't perhaps have something on creating a geographic chart with data on excel, thanks
Thank you Dr. Todd!
You're welcome!
Great stuff - thanks a lot for the help!
You are quite welcome -
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?
At first box plots were rather confusing for me, but this video helped explain the steps in which they are used for.
exactly what I needed! Thanks!
Well Explain. Thanks Todd.
Thanks man, really helpful
You're welcome. Thanks for watching.
tank you for teaching me how to use excel, i reely laik yoe
You're welcome!
well explained about box plot in excel
THANK YOU SO MUCH!!!!!
How do I create a plot with different x-values instead of just the "1" that shows up?
同样问题
@@AT-nm4dn same
bruh i wish my teachers were this good at teaching, i learn more off youtube than in class lol
dude i love 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?
Thanks for the explain....
Thank you very much!
Yesss king go off
thanks ... very helpful post
You're welcome, thanks for watching -
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?
Thank you so much! It helped a lot!
You're welcome, thanks for watching -
what are the practical scenarios we need these plots at work?
Dr. Grande doing Excel Statistical Graph Tutorials (ESGT-Grande) is the new FDA Standard Quaalude Equivalency (SQE). *said w/love*
Dr. Grande just wants to remind you he isn't diagnosing anyone, only speculating about what could be happening in EXCEL.
Thank you😍
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?
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.
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
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