Results 1 to 7 of 7

Thread: Create boxplot, boxplot showing side by side data

  1. #1

    Create boxplot, boxplot showing side by side data



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Can anyone help me create a boxplot , showing side by side data obtained from three activities , of two different groups, with outliers ?
    An example of the data can be:

    * Group 1 * Group 2
    Act 1 Act 2 Act 3 Act 1 Act 2 Act 3
    9 43 26 83 66 98
    89 87 70 24 10 63
    30 95 89 84 55 54
    90 11 22 76 32 83
    71 76 30 17 64 50
    43 45 0 37 73 68
    69 94 73 10 28 46
    10 19 66 64 28 97
    89 69 90 29 83 15
    34 86 81 54 89 37
    53 18 43 100 64 99
    81 99 95 100 94 23
    89 37 24 82 22 82
    59 4 45 0 46 48
    11 20 12 66 46 46

    Thank you !

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,810
    Articles
    0
    Excel Version
    365
    What's your definition of outliers? (Whichever definition you use your sample data contains no outliers.)
    Last edited by p45cal; 2015-08-23 at 04:56 PM.

  3. #3
    Hi,
    This sample is only a example. I have hundreds of values for each column (Act1, Act2 ...).
    What I wanted was to know how to build a boxplot in Excel, as two factors.

    Thanks.


    Quote Originally Posted by p45cal View Post
    What's your definition of outliers? (Whichever definition you use your sample data contains no outliers.)
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	JNeurosciRuralPract_2012_3_3_261_102602_il7.jpg 
Views:	11 
Size:	23.0 KB 
ID:	3866  

  4. #4
    Conjurer hossat's Avatar
    Join Date
    May 2015
    Location
    Algiers, Algeria
    Posts
    114
    Articles
    0
    Excel Version
    365
    Hi,

    I think itís what you are looking for.

    To know how this file was created : http://blog.contextures.com/archives...plot-in-excel/

    Good luck
    BoxPlot - JORMAD.xlsx

  5. #5
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,810
    Articles
    0
    Excel Version
    365
    I asked about outliers so as to know how you wanted to plot data. The jpg you show has outliers plotted beyond the error bars (max/min on many box plots), but clearly the outliers lie outside those error bars so clearly they're not max/min; so what are they?
    I attach a workbook which is work-in-progress which currently uses the conventional 5-number data summary (min, Q1,Q2[=median],Q3, max). Outliers are often defined as those outside 1.5 (or 3) IRQs above Q3/below Q1. Your example data has no outliers with either of these. Sometimes people use the number of standard deviations away from the mean to determine outliers which I have done in the attached where you can change that number in AD1 by adjusting the spinner just below that cell.

    At the moment, these charts will never be like the jpg as outliers seem to be showing above the max and below the min (therefore they're probably not the max/min!).

    So I was merely seeking to find out where/how you want the boxes/error bars/outliers to be plotted.

    Some info on box plots and thresholds: http://www.physics.csbsju.edu/stats/box2.html

    Quote Originally Posted by jormad View Post
    Hi,
    This sample is only a example. I have hundreds of values for each column (Act1, Act2 ...).
    What I wanted was to know how to build a boxplot in Excel, as two factors.
    Attached Files Attached Files

  6. #6
    Thank you all!
    With your help, i solve my problem !!!!

  7. #7
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,810
    Articles
    0
    Excel Version
    365
    jormad, this is a cross post (you have posted the same query elsewhere) without including links to where you have done so.
    Please have a careful read of http://www.excelguru.ca/content.php?184 to understand why this important, then make the necessary additions of links to all sites/threads.
    Ultimately, jormad, it will be to your benefit.

    It would be good netiquette at chandoo.org to indicate your problem is solved, that way no one will waste time solving a problem that has already been solved.
    Likewise at MrExcel.
    The rules on crossposting are all the same.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •