0
You can use the percentile function with values that are multiples of .10 in the function. Say your values were in the cells A2 to A50, you could use these functions for some of the different deciles:
=PERCENTILE(A2:A50,0.1)
=PERCENTILE(A2:A50,0.2)
=PERCENTILE(A2:A50,0.3)
=PERCENTILE(A2:A50,0.4)
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
What is the Spanish word for decile?
decile = decil
What is decile in school grades?
A decile is the same in all things - it is 10%. The second decile is 10-20%
Kindly give an example of decile?
example of decile
What does a second decile ranking mean?
A decile is a method of splitting up a set of ranked data into 10 equally large subsections. If you're in the 2nd decile, you're in the top 20%, if your in the 3rd decile your in the top 30%, and so on. The 2nd decile is a good place to be.
When was Kendra Decile born?
Kendra Decile was born on August 16, 1975, in Santa Barbara, California, USA.
What is Meaning of deciles?
When the data are ordered from smallest to largest, the first decile comprises the smallest 10% of data, the second decile the next 10% and so on, until the top (tenth) decile is the highest 10%.
How do you go about doing decile analysis?
Decile analysis usually groups the customers into 10 percent categories by margin or revenue. Usually the graphs that have the different trends are usually analyzed during the decile analysis.
What is decile?
Decile means one of the ten groups containing an equal number of the items that make up a frequency distribution.
Decile For Ungrouped Data?
sht happens
What is the formula of decile for ungrouped data?
1,5,50
What percentile does the 5th Decile correspond to?
50th percentile or median
What is an inter-decile range?
where you take away the 10% of the data from 90% of the data
