Boxplots in Excel 2013

Creating a Boxplot in Excel 2013

[@Rarest_People]

Youre the best, watching from Tanzania, sending love

[@Petrasex]

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

[@philipmulindwa9722]

Thanks a lot. You have made my day

[@ShigekiMiyakeStoner]

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]

+Shigeki Miyake-Stoner You're right, thanks mate!

[@pault1709]

+Shigeki Miyake-Stoner Thanks, just saved me a headache.

[@pimbolii1000]

+Shigeki Miyake-Stoner Helped me a lot of trouble too!! Thank you very much!

[@AnotherCloseOne]

+Shigeki Miyake-Stoner I knew something was up! You da best!

[@rightiousquesty]

Microsoft is on a crusade against ease of use and intuitive design.

[@marytheyanyan]

Thank you. This was immensely helpful for my intro to statistics class.

[@merhabatube4747]

Thank you very much. It helped me much. It is easy and clearly demonstrated.

[@shafeeqmohamed9784]

Thank you so much. Clear and concise instructions.

[@cesarruiz6544]

Easy to follow, you help a lot for my project.

[@AlexEdstrom]

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.

[@jvoilquin]

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.

[@sharonsingh2736]

Great video and simple steps. Thank you.

[@caglar99]

Amazing, I don't know how you came up with it... Thank you sooo much!

[@patcarla]

this helped me a lot. thank you so much!

[@Ra26cL3DTe]

Great video! Easy to understand.

[@KayYesYouTuber]

Super ! I did not know you could do this in Excel

[@ohnoitsthetippingpoint]

on

[@sportify6517]

Really very helpful

[@patmigajos]

Thank you so much. Very helpful and clear

[@Aurori001]

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]

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.

[@nangsaigon5212]

Thank you so much. You save my project.

[@truonghoangphuc]

Hi you!! from Vietnam ^^

[@rickyharewood]

Brilliant video!! thank you very much!

[@vivian4102]

This was sooooooo helpful!! :)

[@milliedavis7730]

That was so helpful! thank you!

[@mohammedh5766]

Very easy to follow
Thank you!

[@sreechinta6345]

thank you. you were very helpful

[@delilahgarcia1155]

Thank you. However, how would you go about graphing outliers in a box plot on excel?

[@catrinab.4125]

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]

+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]

+Matthew Hunter this is the way my course book teaches it... I'm pretty sure their are many other ways.

[@Melted_Butter]

+Catrina Rawlsgray-Bell sure. but there is a danger in that method as its over simplistic.

[@mamacita7134]

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.

[@MrWebstarTom]

Why the Errorbar for "Max" is not ending at 1297 ?

[@NaturalDarkChocolate]

Thank you for making this video. :-)

[@josuamanurung5914]

thank you so much, Good instruction clearly :)

[@nadjouayousif7313]

i like it, it helped me so much (:

[@kill2honor]

Why are the differences used to make the plot rather than the original numbers?

[@SeagullSniper]

life saver!

[@pimbolii1000]

Thank you very much for your Video! Except for your little mistake with the Maximum it was really helpfull!

[@TomM95]

Thanx! Very helpful!

[@jehiahkyllebacan6815]

thank you!

[@Burgundeh]

thanks very easy to follow

[@3th3r3aldiary]

thank you so much
u helped much

[@cornesmit5211]

Very usefull !!! thank you

[@yogeswarim.rajandran3940]

Thanks so much

[@Cre8tiveye]

very help full thanks :)

[@ElliottPost]

Thank you!

[@Luke-fl9cz]

It doesnt go all the way to the max. Why? Please help

[@judgecochran]

Thank you.

[@tuanvo1875]

cảm ơn nha.

[@gregorydashnaw2522]

Well done - thank you....

[@TheRosey17]

THANK YOU SO MUCH!

[@navaneskumaran3046]

Thanks. I love u

[@koivu11huet39]

I don't have the "Add Chart Element".

[@paoofficial1885]

Thankyou so muchhhhhh

[@xwadaa]

thanks a lot

[@toby6699]

this is not right. The right side error bar should't be 100%

[@cubbwatch]

lol

[@icekong568]

Bad

[@karlynmaggi6565]

ahhh you speak way too fast!