Given the dataset, EmployeeBonus.xlsx, which contains the following fields:
• EmployeeID – unique identifier for each employee
• UsageRate – percent of time employee has been allocated to high profile projects over the past year
• Recognition – how many times the employee has been requested, specifically for high profile projects over the past year
• Leader – how many projects in which the employee has taken on a leadership role during the past year
Use cluster analysis to determine which employees are in the top 5% of the performance metrics listed and are thus up for performance bonuses. Justify your answer using the results of cluster analysis and qualitative descriptions of the top 5%.
Notes:
• n = 107 employees
• normalization might help