Statistical Analysis of Employee Bonus Eligibility: Z-Scores and Performance Metrics
This paper analyzes employee bonus eligibility using statistical methods.
Mia Martinez
Contributor
4.7
58
5 months ago
Preview (2 of 3 Pages)
100%
Purchase to unlock
Page 1
Loading page ...
Statistical Analysis of Employee Bonus Eligibility: Z-Scores and Performance MetricsChallenge #2Alawsuithas beenfiled against your company by a disgruntled employee. It seems that the bonusesyouawarded were flawed and those who were awarded bonuses based on theirhightransactions only did becausethey ignored a large percentage ofcustomerswho would not have purchased anything. Per the company policy,all customers are to be treated equally. The employeesallegedlyignored customers based on gender, ethnicityand age. You cannot afford a lawyer so you are defending yourself in court and based on your knowledgeofStatistics, you are going to show the judge that your employeeswere awarded bonuses correctly.The court wants to review employees with transactions from 80-99. I believe there are six employees in thiscategory. Please complete the chart below. You must convert each employee’s transaction score and OppVolinto a z-score.You then must identify the area (%) that corresponds to the z-score.EmployeeNumberEmployeeNameTransactionz-scoreOppVolz-score123456For Transaction,usethe mean 60.76 and the standard deviation15.11.For OppVol, use the mean385.68 and the standard deviation380.75.To make the decision below, the employee must be above 70% of their peers in transactions and over 38% inOppVol. If theyexceed both metrics, then the employeedoesnot deserve the bonus.Solution:Below is thesnapshot of thetable, which I prepared in the excel to proof my findings:
Page 2
Preview Mode
This document has 3 pages. Sign in to access the full document!