What is the exactly calculation of the fractile function?

[#1]

Hi everybody! I am crazy with the calculation of the fractile function.

I have this table:

vendedor:

LOAD * INLINE [

vendedor, venta

1, 77

2, 79

3, 90

4, 85

5, 66

6, 100

7,88

8,97

9,100

10,87

11,90

12,92

];

when I do in object text the calculation: =fractile( total venta , 0.3) return the value: 85.6

BUT... what is the exactly calculation of the fractile function?

Because I am not statistical so I had to learn how function the fractile function and in this video:  https://www.youtube.com/watch?v=PDzLETjOlL0

the result is 84.4, different of 85.6 (value returned by Qlikview)

who is wrong? what happens?

Thank you in advance !!!

[MK_QSL]

I will search on this and come back to you next week... I am also puzzled... so would definitely work on this.

[#3]

Okey, thank you!!!

[sunny_talwar · Accepted solution]

Attached the logic in the Doc file with the qvw for fractile from 5% till 95% in the increments of 5%

Fractile X% = (N * X%) + (1-X%)

Where N = number of observations in your database (12 in your case)

[sunny_talwar]

Adding the Excel as Document's calculations might look a little messy.

[#6]

Thank you Sunny T !

I apreciate your work really, such in this topic like in the community.

Thank you so much again!

Regards

Agustin

[sunny_talwar]

I am glad I was able to help. My next goal is to fix this document -> Fractile() mystery revealed‌ because the OP might have made a small mistake which might continue to confuse people in the future. But to give the credit to the person who posted it, I wouldn't have got anywhere close in determining what is going on without reverse engineering/play around with his document.

Best,

Sunny

[MK_QSL]

Great work Sunny... !!

[sunny_talwar]

Thanks Manish‌

[Digvijay_Singh]

Thanks a lot Sunny! I also needed this for Sense Box Plot verification.!