How do I calculate Decile?

Fri, 26 Jul 2013 13:40:10 GMT

Greetings

I have the following data. How do I calculate Decile 10%,20%,30%,40%..90%

DATA

100

Thank you

Re: How do I calculate Decile?

Fri, 26 Jul 2013 14:40:25 GMT

hi Viswaranjan

Thanks. I did look at the link before.

In my case For Dimension, I have the following

=if(DATA <= fractile(TOTAL DATA, 0.1), 10,

if(DATA <= fractile(TOTAL DATA, 0.2), 9,

if(DATA <= fractile(TOTAL DATA, 0.3), 8,

if(DATA <= fractile(TOTAL DATA, 0.4), 7,

if(DATA <= fractile(TOTAL DATA, 0.5), 6,

if(DATA <= fractile(TOTAL DATA, 0.6), 5,

if(DATA <= fractile(TOTAL DATA, 0.7), 4,

if(DATA <= fractile(TOTAL DATA, 0.8), 3,

if(DATA <= fractile(TOTAL DATA, 0.9), 2, 1)))))))))

so what will be the expression?

I have used SUM(DATA) for expression, I got the following chart

If I calculate in Excel (note I have used the formula PERCENTILE.EXC(RANGE, K)

I got the folloing answer

So I am bit confused..