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.
@tetlleyplus8 жыл бұрын
+Shigeki Miyake-Stoner You're right, thanks mate!
@pault17098 жыл бұрын
+Shigeki Miyake-Stoner Thanks, just saved me a headache.
@pimbolii10008 жыл бұрын
+Shigeki Miyake-Stoner Helped me a lot of trouble too!! Thank you very much!
@AnotherCloseOne8 жыл бұрын
+Shigeki Miyake-Stoner I knew something was up! You da best!
@rightiousquesty7 жыл бұрын
Microsoft is on a crusade against ease of use and intuitive design.
@Petrasex9 жыл бұрын
This was exactly what I needed for a university statistics assignment, thank you so much!
@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
@AlexEdstrom9 жыл бұрын
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.
@Aurori00110 жыл бұрын
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?
@thoesing9 жыл бұрын
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.
@shafeeqmohamed97849 жыл бұрын
Thank you so much. Clear and concise instructions.
@sharonsingh27366 жыл бұрын
Great video and simple steps. Thank you.
@merhabatube47479 жыл бұрын
Thank you very much. It helped me much. It is easy and clearly demonstrated.
@jvoilquin10 жыл бұрын
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.
@marytheyanyan9 жыл бұрын
Thank you. This was immensely helpful for my intro to statistics class.
@philipmulindwa97222 жыл бұрын
Thanks a lot. You have made my day
@cesarruiz654410 жыл бұрын
Easy to follow, you help a lot for my project.
@caglar999 жыл бұрын
Amazing, I don't know how you came up with it... Thank you sooo much!
@MrWebstarTom8 жыл бұрын
Why the Errorbar for "Max" is not ending at 1297 ?
@Ra26cL3DTe9 жыл бұрын
Great video! Easy to understand.
@mamacita71349 жыл бұрын
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.41259 жыл бұрын
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_Butter9 жыл бұрын
+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.41259 жыл бұрын
+Matthew Hunter this is the way my course book teaches it... I'm pretty sure their are many other ways.
@Melted_Butter9 жыл бұрын
+Catrina Rawlsgray-Bell sure. but there is a danger in that method as its over simplistic.
@kill2honor8 жыл бұрын
Why are the differences used to make the plot rather than the original numbers?
@delilahgarcia11559 жыл бұрын
Thank you. However, how would you go about graphing outliers in a box plot on excel?
@patmigajos9 жыл бұрын
Thank you so much. Very helpful and clear
@patcarla9 жыл бұрын
this helped me a lot. thank you so much!
@rickyharewood6 жыл бұрын
Brilliant video!! thank you very much!
@mohammedh57667 жыл бұрын
Very easy to follow Thank you!
@KayYesYouTuber8 жыл бұрын
Super ! I did not know you could do this in Excel
@ohnoitsthetippingpoint7 жыл бұрын
on
@sportify65174 жыл бұрын
Really very helpful
@milliedavis77308 жыл бұрын
That was so helpful! thank you!
@highend94057 жыл бұрын
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.
@sreechinta63459 жыл бұрын
thank you. you were very helpful
@Luke-fl9cz9 жыл бұрын
It doesnt go all the way to the max. Why? Please help
@SeagullSniper9 жыл бұрын
life saver!
@vivian41028 жыл бұрын
This was sooooooo helpful!! :)
@Burgundeh8 жыл бұрын
thanks very easy to follow
@TomM959 жыл бұрын
Thanx! Very helpful!
@Kirsty4Jesus7 жыл бұрын
thank you so much u helped much
@nangsaigon52129 жыл бұрын
Thank you so much. You save my project.
@josuamanurung59147 жыл бұрын
thank you so much, Good instruction clearly :)
@NaturalDarkChocolate8 жыл бұрын
Thank you for making this video. :-)
@truonghoangphuc6 жыл бұрын
Hi you!! from Vietnam ^^
@cornesmit52119 жыл бұрын
Very usefull !!! thank you
@pimbolii10008 жыл бұрын
Thank you very much for your Video! Except for your little mistake with the Maximum it was really helpfull!
@gregorydashnaw25229 жыл бұрын
Well done - thank you....
@jehiahkyllebacan68152 жыл бұрын
thank you!
@koivu11huet399 жыл бұрын
I don't have the "Add Chart Element".
@TheRosey1710 жыл бұрын
THANK YOU SO MUCH!
@ElliottPost9 жыл бұрын
Thank you!
@Cre8tiveye9 жыл бұрын
very help full thanks :)
@yogeswarim.rajandran39404 жыл бұрын
Thanks so much
@nadjouayousif73137 жыл бұрын
i like it, it helped me so much (:
@judgecochran8 жыл бұрын
Thank you.
@navaneskumaran30465 жыл бұрын
Thanks. I love u
@paoofficial18856 жыл бұрын
Thankyou so muchhhhhh
@tuanvo18757 жыл бұрын
cảm ơn nha.
@xwadaa7 жыл бұрын
thanks a lot
@toby66998 жыл бұрын
this is not right. The right side error bar should't be 100%