How to Create a Box and Whisker Plot in Excel 2003

Step by step instructions on how to create a Box and Whisker Plot in Excel 2003.

I think this can be done easier in a newer version of Excel but for those people still using Excel 2003 (many schools and companies I'm sure) here are step by step instructions on how to create a Box and Whisker Plot in Excel 2003.

[JamieJamBottle]

You sir have saved my life!!! Thank-you much!!! My Maths Statistics assignment is due tomorrow and I had to graph my data using a box and whisker plot, and had no idea how to do it on Excel 2003. All the other videos seemed useless and just confusing, but because this went through step by step in such detail it has been the only one that has worked for me! Thank-you so very much!! Splendid job!

[Bengaliization]

Thank you so very much! You made this a very easy step by step process, I'm very thankful!

[Itouchangels]

Thank you so much, my computer broke and I'm stuck using the public library's window's 2003. I have to say, I'm very greatful for your help.

[duckduck]

Thanks a lot! Extremely helpful and very well explained! I usually use SPSS, but I dont have a a license right now - so the excel solution came in quite handy!

[MrReive]

Thanks for the feedback.
Glad the video helped you.

[MrReive]

Glad it helped. Thanks for the comment.

[MrReive]

Here is an example:
Say your min=9 and Q1=12. If made a stacked bar chart using the values 9 and 12 the first bar would be 9 wide and the bar beside the 9 would be 12 wide. For a total of 21 wide which isn’t what you wanted. So instead you plot 9 and 3 (12-9) and now you get the first bar 9 wide and the bar beside 3 wide for a total of 12 wide. This would go along with making a box and whisker plot, you would put a point for the min at 9 and a point for the Q1 at 12.

Hope this helps.

[MrReive]

Yes that is correct, Q1 is 25% and Q3 is 75%. I don't show it but if the data was in A1 to A30 then you can use the Excel command =QUARTILE(A1:A30, 1) to get Q1 and =QUARTILE(A1:A30, 3) to get Q3.

[MrReive]

I have never seen the mean used in a box plot. But if you want the mean use the average function. For example =AVERAGE(A2:A30).

[KevinKao]

great job!

Where are you getting your Q1 and Q3 numbers? do they represent 25% and 75%?

[dr.debanjanadas]

thank you so much.can you please say if i want to box plot using mean

[AliceVibe]

just wondering, why do we have to plot down the differences, why not just the min, Q1, Median, Q3 and max?

[AbbyRocks]

How do you do box and whisker plots with negative numbers or zeroes? Because I'm doing a project, and I can't seem to figure out how to do a box plot with zeroes.. Please help