Percentile Help!!!!!

  • Thread starter Thread starter Carmela
  • Start date Start date
C

Carmela

I was asked to figure out the 80th and 90th percentile of certain
numbers.
Let say the numbers are as such:
80th 90th
120 ? ?
110 ? ?
102 ? ?
136 ? ?
125 ? ?
totaL: 693

how do I find the 80th and and 90th percentil for all these numbers.
Can anyone help.

Thanks
CD
 
Carmela -

Use the PERCENTILE worksheet function.

For example, if the data set is in A1:A693, in some other cell enter

=PERCENTILE(A1:A693,0.80)

and in another cell enter

=PERCENTILE(A1:A693,0.90)

- Mike Middleton, www.usfca.edu/~middleton

++++++++++++++++++++++++++++++++
 
Back
Top