Create boxplot, boxplot showing side by side data

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:


Thank you !

What's your definition of outliers? (Whichever definition you use your sample data contains no outliers.)

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.

p45cal said:

What's your definition of outliers? (Whichever definition you use your sample data contains no outliers.)

Click to expand...

Hi,

I think it’s what you are looking for.

To know how this file was created : http://blog.contextures.com/archives/2013/06/11/create-a-simple-box-plot-in-excel/

Good luck
View attachment BoxPlot - JORMAD.xlsx

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

jormad said:

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.

Click to expand...

Thank you all!
With your help, i solve my problem :clap2::clap2::clap2:!!!!

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.