https://issues.apache.org/ooo/show_bug.cgi?id=126061
Regina Henschel <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED CC| |[email protected] Resolution|--- |NOT_AN_ISSUE --- Comment #1 from Regina Henschel <[email protected]> --- The results are as specified in chapter 6.18.64 QUARTILE http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018750_715980110 and chapter 6.18.57 PERCENTILE http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018736_715980110 For example =QUARTILE(F2:F11;3) on sheet Q6-10 =QUARTILE(F2:F11;3) equals =PERCENTILE(F2:F11;0.75) For the algorithm given in 6.18.57 Step 1: already sorted 1,2,3,4,5,6,7,8,9,10 Step 2: n=10 r=1+0.75*(10-1)=7.75 I=7 D=0.75 Step 3: Y_I=Y_7 = 7 Y_{I+1}=Y_8=8 PERCENTILE=Y_I+D*(Y_{I+1}-Y_I)=7+0.75*(8-1)=7.75 -- You are receiving this mail because: You are the assignee for the issue. You are watching all issue changes.
