MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Statistical Functions

Posted by Zuzana Fabian on November 06, 2001 7:08 AM

Good morning (:

I am having some trouble figuring out how to use excels statistical functions. I have a set of data that reflects 10,15,2,4

..and I need to pick out where the top 20% and the bottom 20% of those numbers starts.

Is there a function that can help me do this amongst a large set of data?

I greatly appreciate your help.

Zuzana Fabian

Posted by Mark W. on November 06, 2001 8:49 AM

Did you examine the PERCENTILE worksheet function?
The 20th percentile of {10,15,2,4} is 3.2, and the
80th percentile of {10,15,2,4} is 12.