No video

Boxplots in Excel 2013

  Рет қаралды 459,440

Paula Schute

Paula Schute

Күн бұрын

Creating a Boxplot in Excel 2013

Пікірлер: 74
@ShigekiMiyakeStoner
@ShigekiMiyakeStoner 9 жыл бұрын
Yes, please note that the right (max) whisker in this demonstration is generated incorrectly. The max error should not be 100%, but rather "custom" set to the Max-Q3 difference.
@tetlleyplus
@tetlleyplus 8 жыл бұрын
+Shigeki Miyake-Stoner You're right, thanks mate!
@pault1709
@pault1709 8 жыл бұрын
+Shigeki Miyake-Stoner Thanks, just saved me a headache.
@pimbolii1000
@pimbolii1000 8 жыл бұрын
+Shigeki Miyake-Stoner Helped me a lot of trouble too!! Thank you very much!
@AnotherCloseOne
@AnotherCloseOne 8 жыл бұрын
+Shigeki Miyake-Stoner I knew something was up! You da best!
@rightiousquesty
@rightiousquesty 7 жыл бұрын
Microsoft is on a crusade against ease of use and intuitive design.
@Petrasex
@Petrasex 9 жыл бұрын
This was exactly what I needed for a university statistics assignment, thank you so much!
@viniciusvbloureiro
@viniciusvbloureiro Жыл бұрын
Parabens pelo video, sou brasileiro, tava tendo dificuldade de montar um boxplot no excel 2013, ja tinha visto varios videos e com ajuda do seu video consegui fazer um. Muito obrigado
@AlexEdstrom
@AlexEdstrom 9 жыл бұрын
As other have pointed out, the graph doesn't include the maximum error on the right side of the plot. The easiest way to fix this is to select the maximum quadrant (that you'll make clear-colored) and to set the error bar in this region using another minus direction error bar. Again, set to 100% and then you're good to go.
@Aurori001
@Aurori001 10 жыл бұрын
Is the whisker on the right side really correct?!? Data is going up to 1297 but your whisker only goes to ca. 1050...?!? I guess you have taken the wrong area to add the error bar, dont I?
@thoesing
@thoesing 9 жыл бұрын
Aurori001 Instead of using a Percentage of 100% for the Positive Error Bars, use Custom and then select both of the final difference values while holding Ctrl. Also, this doesn't address potential outliers, but it's not bad for a quick & dirty boxplot.
@shafeeqmohamed9784
@shafeeqmohamed9784 9 жыл бұрын
Thank you so much. Clear and concise instructions.
@sharonsingh2736
@sharonsingh2736 6 жыл бұрын
Great video and simple steps. Thank you.
@merhabatube4747
@merhabatube4747 9 жыл бұрын
Thank you very much. It helped me much. It is easy and clearly demonstrated.
@jvoilquin
@jvoilquin 10 жыл бұрын
Thank you. Your instruction is easy to follow. If you only can make your voice a little bit louder and clear, it would be even better, so people doesn't need to repeat the video three times. Anyway, thank you soo much.
@marytheyanyan
@marytheyanyan 9 жыл бұрын
Thank you. This was immensely helpful for my intro to statistics class.
@philipmulindwa9722
@philipmulindwa9722 2 жыл бұрын
Thanks a lot. You have made my day
@cesarruiz6544
@cesarruiz6544 10 жыл бұрын
Easy to follow, you help a lot for my project.
@caglar99
@caglar99 9 жыл бұрын
Amazing, I don't know how you came up with it... Thank you sooo much!
@MrWebstarTom
@MrWebstarTom 8 жыл бұрын
Why the Errorbar for "Max" is not ending at 1297 ?
@Ra26cL3DTe
@Ra26cL3DTe 9 жыл бұрын
Great video! Easy to understand.
@mamacita7134
@mamacita7134 9 жыл бұрын
This is wrong. The error amount for the error bar to the right should be at the fixed value of the difference of the MAX and Q3.
@catrinab.4125
@catrinab.4125 9 жыл бұрын
If you want to ensure that the whiskers are correct. Compute the lower and upper boundaries. Then find the largest data value that is less than the upper boundary and extend the whisker from Q3 to that value. Do the same for the smallest data value. Find the data that is greater than the lower boundary and draw the whisker from Q1 to that value. And any data beyond those boundaries are outliers, mark them with an X.
@Melted_Butter
@Melted_Butter 9 жыл бұрын
+Catrina Rawlsgray-Bell - not sure if that is the most accurate way. will only exclude single uppermost outlier. You may have more than one. Would probably need to use some kind of statisticlly determined cut off.
@catrinab.4125
@catrinab.4125 9 жыл бұрын
+Matthew Hunter this is the way my course book teaches it... I'm pretty sure their are many other ways.
@Melted_Butter
@Melted_Butter 9 жыл бұрын
+Catrina Rawlsgray-Bell sure. but there is a danger in that method as its over simplistic.
@kill2honor
@kill2honor 8 жыл бұрын
Why are the differences used to make the plot rather than the original numbers?
@delilahgarcia1155
@delilahgarcia1155 9 жыл бұрын
Thank you. However, how would you go about graphing outliers in a box plot on excel?
@patmigajos
@patmigajos 9 жыл бұрын
Thank you so much. Very helpful and clear
@patcarla
@patcarla 9 жыл бұрын
this helped me a lot. thank you so much!
@rickyharewood
@rickyharewood 6 жыл бұрын
Brilliant video!! thank you very much!
@mohammedh5766
@mohammedh5766 7 жыл бұрын
Very easy to follow Thank you!
@KayYesYouTuber
@KayYesYouTuber 8 жыл бұрын
Super ! I did not know you could do this in Excel
@ohnoitsthetippingpoint
@ohnoitsthetippingpoint 7 жыл бұрын
on
@sportify6517
@sportify6517 4 жыл бұрын
Really very helpful
@milliedavis7730
@milliedavis7730 8 жыл бұрын
That was so helpful! thank you!
@highend9405
@highend9405 7 жыл бұрын
When I calculate Quartiles using the formula approach I receive different # from the one I find by using the quartile function. I know that the formula approach is the right one, but I don't know If I really can rely on quartile function in excell.
@sreechinta6345
@sreechinta6345 9 жыл бұрын
thank you. you were very helpful
@Luke-fl9cz
@Luke-fl9cz 9 жыл бұрын
It doesnt go all the way to the max. Why? Please help
@SeagullSniper
@SeagullSniper 9 жыл бұрын
life saver!
@vivian4102
@vivian4102 8 жыл бұрын
This was sooooooo helpful!! :)
@Burgundeh
@Burgundeh 8 жыл бұрын
thanks very easy to follow
@TomM95
@TomM95 9 жыл бұрын
Thanx! Very helpful!
@Kirsty4Jesus
@Kirsty4Jesus 7 жыл бұрын
thank you so much u helped much
@nangsaigon5212
@nangsaigon5212 9 жыл бұрын
Thank you so much. You save my project.
@josuamanurung5914
@josuamanurung5914 7 жыл бұрын
thank you so much, Good instruction clearly :)
@NaturalDarkChocolate
@NaturalDarkChocolate 8 жыл бұрын
Thank you for making this video. :-)
@truonghoangphuc
@truonghoangphuc 6 жыл бұрын
Hi you!! from Vietnam ^^
@cornesmit5211
@cornesmit5211 9 жыл бұрын
Very usefull !!! thank you
@pimbolii1000
@pimbolii1000 8 жыл бұрын
Thank you very much for your Video! Except for your little mistake with the Maximum it was really helpfull!
@gregorydashnaw2522
@gregorydashnaw2522 9 жыл бұрын
Well done - thank you....
@jehiahkyllebacan6815
@jehiahkyllebacan6815 2 жыл бұрын
thank you!
@koivu11huet39
@koivu11huet39 9 жыл бұрын
I don't have the "Add Chart Element".
@TheRosey17
@TheRosey17 10 жыл бұрын
THANK YOU SO MUCH!
@ElliottPost
@ElliottPost 9 жыл бұрын
Thank you!
@Cre8tiveye
@Cre8tiveye 9 жыл бұрын
very help full thanks :)
@yogeswarim.rajandran3940
@yogeswarim.rajandran3940 4 жыл бұрын
Thanks so much
@nadjouayousif7313
@nadjouayousif7313 7 жыл бұрын
i like it, it helped me so much (:
@judgecochran
@judgecochran 8 жыл бұрын
Thank you.
@navaneskumaran3046
@navaneskumaran3046 5 жыл бұрын
Thanks. I love u
@paoofficial1885
@paoofficial1885 6 жыл бұрын
Thankyou so muchhhhhh
@tuanvo1875
@tuanvo1875 7 жыл бұрын
cảm ơn nha.
@xwadaa
@xwadaa 7 жыл бұрын
thanks a lot
@toby6699
@toby6699 8 жыл бұрын
this is not right. The right side error bar should't be 100%
@cubbwatch
@cubbwatch 9 жыл бұрын
lol
@icekong568
@icekong568 8 жыл бұрын
Bad
@karlynmaggi6565
@karlynmaggi6565 4 жыл бұрын
ahhh you speak way too fast!
Excel 2013: Frequency Function & Creating Histograms
6:33
Kevin Olson
Рет қаралды 664 М.
How to Create a Box and Whisker Plot in Excel 2010
12:27
Mr. Reive
Рет қаралды 507 М.
Can This Bubble Save My Life? 😱
00:55
Topper Guild
Рет қаралды 85 МЛН
Running With Bigger And Bigger Feastables
00:17
MrBeast
Рет қаралды 162 МЛН
Les 7 Excel boxplot maken
13:04
Frederik Truyen
Рет қаралды 31 М.
Creating a Histogram with Excel 2013
11:02
Jonathan Alexander
Рет қаралды 139 М.
Top 10 Most Important Excel Formulas - Made Easy!
27:19
The Organic Chemistry Tutor
Рет қаралды 7 МЛН
Box and Whisker Plot Using Excel 2016
5:59
Maggie Winslow
Рет қаралды 214 М.
Making a Box Plot on Excel 2013
14:30
Lucas Burge
Рет қаралды 80 М.
How To... Create a Pareto Chart in Excel 2013
8:34
Eugene O'Loughlin
Рет қаралды 116 М.
Progress Circle Chart in Excel - Part 1 of 2
7:11
Excel Campus - Jon
Рет қаралды 396 М.
Understand Box Plots in Statistics (Box-and-Whisker Plots) - [6-8-23]
19:55
Creating A Boxplot Using Excel
18:56
Jermaine Gordon
Рет қаралды 13 М.
How To... Draw a Simple Box Plot in Excel 2010
9:03
Eugene O'Loughlin
Рет қаралды 378 М.
Can This Bubble Save My Life? 😱
00:55
Topper Guild
Рет қаралды 85 МЛН