Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Factile Function error

Hi All,

I have data something like this.

 

0
0
0
0
0
0
0
0.0017412
0.0267893
0.0302776
0.0325067
0.1604363
0.162742
0.1701797
0.1712399
0.2154379

When I apply fractile function it is giving me below mentioned results:

25th percentile: 0.0325067

50th percentile: 0.162742

75th percentile: 0.1712399

100th percentile:0.2154379

But I doubt whether it is correct. Can someone explain it to me?

Thanks in advance.

Regards,

Rishikesh

1 Solution

Accepted Solutions
swuehl
MVP
MVP

I can't reproduce your results, I do get these

Fractile(VAL, 0.25) = 0

Fractile(VAL, 0.5) = 0.01426525

Fractile(VAL, 0.75)=0.161012725

Fractile(VAL, 1) = 0.2154379

which seems reasonable.

View solution in original post

1 Reply
swuehl
MVP
MVP

I can't reproduce your results, I do get these

Fractile(VAL, 0.25) = 0

Fractile(VAL, 0.5) = 0.01426525

Fractile(VAL, 0.75)=0.161012725

Fractile(VAL, 1) = 0.2154379

which seems reasonable.