Share via

Box and Whisker plots in Excel

Anonymous
2018-08-08T15:36:30+00:00

Hi all,

I'm making some plots in Excel and could use some help interpreting the data.  I've attached a screenshot.  I understand that the circles are outliers, but why are so many shown in some cases and why are some between Q1 and Q3?  Any insight would be helpful.

Thanks in advance,

Mark

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2018-08-08T19:26:24+00:00

    An article describing some of the design decisions made by the "Excel team" is

    https://www.microsoft.com/en-us/microsoft-365/blog/2015/08/18/visualize-statistics-with-histogram-pareto-and-box-and-whisker-charts/

    which includes

    "For outliers, we designed the Box and Whisker chart to follow the Tukey industry standard, which states that values are considered outliers only if they lie 1.5 times the length of the box (known as the interquartile range) from either end of the box."

    For more insight, it may be helpful if you post a data set for one of your box-whisker charts so we can replicate your results.

    Also, specify the version of Excel (from Excel's topmost menu choose Excel > About Microsoft Excel). I'm currently using general release 16.15.

    2 people found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-08-08T18:12:21+00:00

    Rohn007

    Something wrong with your Browser. Here is what the Op sent:

    __________

    Disclaimer:

    The questions, discussions, opinions, replies & answers I create, are solely mine and mine alone and do not reflect upon my position as a Volunteer Moderator.

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2018-08-08T16:09:03+00:00

    Your screen shot did not come through

    .

    . ...........************************************

    **************** Screen Capture **************

    . ...........************************************

    Note:

    .

    To insert pictures into the Answers forum you have to do the following:

    .

    * Using your screen capture tool (ie Snip, FastStone Capture, PicPick), save the capture to your HD

    * Click on the "Insert Picture" button at the top of the input dialog

    * Browse to find the saved image file

    * upload it

    Here is a wiki with more detailed instructions:

    .

    http://answers.microsoft.com/en-us/feedback/wik...

    .

    .

    ***************

    .

    .

    I have created a (very) short WIKI describing the Snip tool and Textify.

    Textify captures text from dialog boxes you normally cannot select and copy from.

    .

    http://answers.microsoft.com/en-us/windows/wiki...

    .

    ............***************************************

    **************** End Screen Capture ***************

    ............***************************************

    .

    0 comments