thisisrahul
Active Member
- Joined
- Sep 2, 2008
- Messages
- 287
Hi,
Is there a way through which i can get values as D1, D2, D3 ....D10 for a data series depends if its belong to D1 deciles or D2 deciles etc.
Quartile function of excel gives each quartile no but how can i divide my data series in Q1, Q2, Q3 and Q4 depends on which quartile they fall in.
I need this for Quartile and Decile both.
-----------
Rahul
Is there a way through which i can get values as D1, D2, D3 ....D10 for a data series depends if its belong to D1 deciles or D2 deciles etc.
Quartile function of excel gives each quartile no but how can i divide my data series in Q1, Q2, Q3 and Q4 depends on which quartile they fall in.
I need this for Quartile and Decile both.
-----------
Rahul