Factile Function error

Fri, 10 Jul 2015 06:04:34 GMT

Hi All,

I have data something like this.

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

Re: Factile Function error

swuehl — Fri, 10 Jul 2015 07:07:53 GMT

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.