Excel percentile puzzle

lancegallagher_expertsexchange
lancegallagher_expertsexchange used Ask the Experts™
on
Hello experts, I need some help trying to figure out this excel percentile puzzle.

I have only been provided with salary data for the 25th, 50th and 75th percentile, and cannot get the source data. Does anyone know the best formula to calculate what the 10th and 90th percentile would be.

10th percentile      = ?
25th percentile      = 32000
50th percentile      = 35500
75th percentile      = 38000
90th percentile      = ?

Any help is greatly appreciated!!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
This appears to be statistics.  

I'd use statistical formulas specifically stdev, as this appears to be based on a bell curve style distribution.
Hello ScriptAddict

Thanks for your help. I was able to figure it out using STDEV as you suggested to find out the value at 0% and 100% and the applied formula to find out the 10% and 90% once I had this range of values.

Many Thanks !
Glad I could help!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial