Home / Expert Answers / Computer Science / given-the-dataset-employeebonus-xlsx-which-contains-the-following-fields-employeeid-uniqu-pa660

(Solved): Given the dataset, EmployeeBonus.xlsx, which contains the following fields: EmployeeID uniqu ...



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



We have an Answer from Expert

View Expert Answer

Expert Answer



To use cluster analysis to determine the top 5% of employees based on performance metrics, we can follow these steps:

Load the EmployeeBonus.xlsx file into a software program that supports cluster analysis, such as R or Python.


We have an Answer from Expert

Buy This Answer $5

Place Order

We Provide Services Across The Globe