B
BRob
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
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