Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.