Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentile Analysis Across 2 Columns
I'm wanting to calculate decile (or equivalent percentile) salaries to see
if there is any difference between 2 departments (A and B). So dummy data looks like : Dept Salary A £52,670 A £53,530 A £56,117 B £41,437 A £51,809 B £53,530 A £32,803 B £52,670 B £35,398 A £52,670 B £31,077 A £35,398 A £23,831 B £17,100 B £15,929 A £19,602 A £16,688 B £16,307 B £16,688 B £14,065 Range names, which cover about 2000 rows of actual data are used "Dept" and "Salary" Can SKS help out Thanks, Rob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct and Percentile | Excel Worksheet Functions | |||
to get its k-value from percentile and array | Excel Worksheet Functions | |||
Conditional Percentile | Excel Discussion (Misc queries) | |||
Analysis ToolPak installed but no Data Analysis option | Excel Discussion (Misc queries) | |||
percentile | Excel Worksheet Functions |