| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Calculating percentiles
I have been asked to analyze what the % of Population of employees have
salaries in the 25th, 50th and 75th percentile of their ranges. I have never created a formula that calculates percentile. I did a search and did not see any discussions on this question. Any help would be appreciated. Thanks |
|
#2
|
|||
|
|||
|
kswan -
You don't need a formula. You can use a worksheet function like PERCENTILE or QUARTILE. See Excel's Help for more information. - Mike www.mikemiddleton.com "kswan" wrote in message ... I have been asked to analyze what the % of Population of employees have salaries in the 25th, 50th and 75th percentile of their ranges. I have never created a formula that calculates percentile. I did a search and did not see any discussions on this question. Any help would be appreciated. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
| calculating debtor days (DSO) | Excel Worksheet Functions | |||
| not calculating formulas | Excel Discussion (Misc queries) | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! | Excel Discussion (Misc queries) | |||
Linear Mode
