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?