answersLogoWhite

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)

User Avatar

Wiki User

10y ago

What else can I help you with?