Quartiles and Deciles - Excel 2013
RIDNIK
Posted messages
2
Status
Membre
-
RIDNIK Posted messages 2 Status Membre -
RIDNIK Posted messages 2 Status Membre -
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
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