View original (French)

Quartiles and Deciles - Excel 2013

RIDNIK Posted messages 2 Status Member -  
RIDNIK Posted messages 2 Status Member -
Hello everyone!

I have a question regarding Excel 2013, specifically about quartiles and deciles.

Explanation

I have a table that shows the out-of-pocket expenses of members in the mutual fund.
So I have 344 rows of out-of-pocket amounts by members with amounts ranging from €0.00 to €329.99.

I am asked for the detailed global out-of-pocket expenses divided into 3 quartiles and for the 9th and 10th deciles.

For the calculation of the quartiles, the formulas used are as follows:

Quartile 1 =QUARTILE(E2:E346;1) which is €0
Quartile 2 =QUARTILE(E2:E346;2) which is €3.425
Quartile 3 =QUARTILE(E2:E346;3) which is €49.59

So far, I think this is correct.

However, regarding the decile, I’m stuck. I have done some research online, but nothing seems to work.

I found this formula: =PERCENTILE(E2:E346;0.1) but the result is always 0. It seems the decile formula is not available.

Could someone enlighten me?

Thank you in advance.

RIDNIK

2 answers

  1.
    ccm81 Posted messages 11033 Status Member 2 434
     
    Hello

    For the first decile, your formula
    =PERCENTILE(E2:E346,0.1) is correct

    Make sure that
    - you have used a comma
    - your cell is formatted as a number with 2 decimal places

    Best regards
    2