View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Creating notches in box whisker plots in Microsoft Excel

Use this set of xy pairs to draw a notched version

X Y
Min 1 3
Min 1 5
Min 1 4
25th 3 4
25th 3 7
TopNotchLeft 5.342592593 7
TopNotchMid 5.5 6.5
TopNotchRight 5.657407407 7
75th 8 7
75th 8 1
BottomNotchRight 5.657407407 1
BottomNotchMid 5.5 1.5
BottomNotchLeft 5.342592593 1
25th 3 1
25th 3 4
Skip
Median 5.5 1.5
Median 5.5 6.5
Skip
75th 8 4
Max 10 4
Max 10 5
Max 10 3

The formula for X value of NotchLeft is
=MEDIAN($A$1:$A$50)-(1.7*((1.25*(PERCENTILE($A$1:$A$50,0.75)-PERCENTILE($A$1:$A$50,0.25))/(1.35*50))))

The formula for X value of NotchRight is
=MEDIAN($A$1:$A$50)+(1.7*((1.25*(PERCENTILE($A$1:$ A$50,0.75)-PERCENTILE($A$1:$A$50,0.25))/(1.35*50))))

All other formula are as William W. Dorner's example.

Cheers
Andy

wrote:
On Jun 15, 8:47 am, Andy Pope wrote:

Hi,

The technique describes how to use an xy-scatter to construct the boxes.

You need to add a few more xy pairs in order to reduce the width of the
Median line and form the notches.

Cheers
Andy



wrote:

Does anyone know how to create the notches in the verticalboxwhisker
charts?


An example can be found in figure 10 of the following article:


http://www.qualitydigest.com/oct97/html/excel.html

Thank you!!- Hide quoted text -


- Show quoted text -



Can you elaborate on the technique?