Skip to Content
0
Former Member
Mar 18, 2009 at 05:59 PM

Quartile formula

110 Views

I have avg cost per shop for 200 different shops. My shops avg cost rate is "x"....I want to be able to show that my cost rate is below the 75th percentile in this 200 shop sample. Can this be done in a formula? Can I say show that my cost rate is $1000 and the 75th percentile rate is $2500?

Thank you for any suggestions!