M
mcgrathml
Hi,
Just wondering can Excel do the following:-
A large worksheet consists of employees with the decade they joined.
employee decade
1 80
2 90
3 70
etc.
The request is to produce a random sampling but taking into account the
percentage of employees who joined in a particular decade.
So for example (simplified)
Decade Percentage
70's 10%
80's 30%
90's 45%
00 15%
In other words if 1000 employees are extracted from the main worksheet,
100 of them should be randomly chosen from the 70's and 150 should
be from the 00's.
I can divide the worksheet per decade and produce a random sample, but
wonder is there a means of doing this with one sheet.
All help gratefully received,
Just wondering can Excel do the following:-
A large worksheet consists of employees with the decade they joined.
employee decade
1 80
2 90
3 70
etc.
The request is to produce a random sampling but taking into account the
percentage of employees who joined in a particular decade.
So for example (simplified)
Decade Percentage
70's 10%
80's 30%
90's 45%
00 15%
In other words if 1000 employees are extracted from the main worksheet,
100 of them should be randomly chosen from the 70's and 150 should
be from the 00's.
I can divide the worksheet per decade and produce a random sample, but
wonder is there a means of doing this with one sheet.
All help gratefully received,