Forum Discussion
Helper IIDividing data into equal quarters
Community ChampionPlease provide sample data and a depiction of what you are trying to achieve.
Helper IIThanks for you reply. Here is a small sample:
Id Gender Hourly Rate
1110 Female 11.1
1111 Male 24.71
1112 Female 17.31
1113 Female 8.94
1114 Male 9.63
1115 Male 9.63
1116 Female 8.43
1117 Female 9.51
1118 Female 9.63
1119 Female 8.94
1120 Male 10.49
1121 Male 13.49
1122 Female 8.94
1123 Female 9.63
1124 Female 8.94
1125 Female 17.55
1126 Male 9.43
1127 Female 14.91
1128 Female 12.35
1129 Male 9.43
1130 Female 54.48
1131 Female 15.24
1132 Female 15.93- Naomig2088
it would need to be divded into 4 equal parts with an even gender distribution across the hourly pay quarters. Thanks
- PaulDBrown
Thank you for providing data.
What do you mean by "4 equal parts" etc...?
It would be really helpful if you posted a depiction of the expected result
- Naomig2088
So, I would need to divide the data into 4 equal quarters based on hourly rate, lowest to highest. As an outcome, I would need a table with the number of employees in each quarter, with their hourly rate and would need for the gender to be taken into account- there are 7 males and 16 females so they would need to be distributed evenly across the hourly pay quartiles. I hope that makes sense!