I want a function in Excel that gives me quartile position (e.g. Q1, Q2, Q3 and Q4) or Decile position (e.g. D1, D2 ets) of a number in the data set.
for example in the given data set
1 belongs to Q1
7 belongs to Q4
similar for Decile also.
I also want a way where i can...