XL-Data-Pivot-Chart-Box-Vertical
XL-Data-Pivot-Chart-Box-Vertical
> y      = Volume [containers] - Statistical Box-and-Whisker
> x      = Countries (Asia)

XL-Data-Pivot-Chart-Box-Vertical
> y      = Dwell [days] - Statistical Box-and-Whisker
> x      = Countries (Asia)

XL-Data-Box
XL-Data-Box

Box-Plots (2 categories side-by-side)
Excel
> Ctrl + Click to select 2 columns: 
     Date          = x Category 
     Close (Price) = y Value
> Insert > Insert Statistic Chart > Box and Whisker Plot
Vertical Box Plot IQR = Q3−Q1 whisker_hi [Q3, non-outlier_max] whisker_lo [non-outlier_min, Q1] Q4 = max outlier_hi > fence_hi fence_hi = Q3 + 1.5 × IQR non-outlier_max Q3 = 3rd-quartile mean_hi → R-skew (+) Q2 = 2nd-quartile = median mean_lo → L-skew (−) Q1 = 1st-quartile non-outlier_min fence_lo = Q1 − 1.5 × IQR outlier_lo < fence_lo Q0 = min 
XL-Data-Box
--------------------------------------------
Q4         = max

outlier_hi > fence_hi
fence_hi   = Q3 + 1.5 * IQR
whisker_hi = [Q3, last-non-outlier]

Q3         = 3rd-quartile

mean_hi    = > median = R-skew-tail (+)

Q2         = 2nd-quartile = median

mean_lo    = < median = L-skew-tail (-)

Q1         = 1st-quartile

whisker_lo = [1st-non-outlier, Q1]
fence_lo   = Q1 - 1.5 * IQR
outlier_lo < fence_lo 
             
Q0         = min
--------------------------------------------
             
IQR = Q3 - Q1