I just need the questions answered based on the information
I just need the questions answered based on the information below..
Challenge #2
A lawsuit has been filed against your company by a disgruntled employee. It seems that the bonuses you awarded were flawed and those who were awarded bonuses based on their high transactions only did because they ignored a large percentage of customers who would not have purchased anything. Per the company policy, all customers are to be treated equally. The employees allegedly ignored customers based on gender, ethnicity and age. You cannot afford a lawyer so you are defending yourself in court and based on your knowledge of Statistics, you are going to show the judge that your employees were awarded bonuses correctly.
The court wants to review employees with transactions from 80-99. I believe there are six employees in this category. Please complete the chart below. You must convert each employee’s transaction score and OppVol into a z-score. You then must identify the area (%) that corresponds to the z-score.
To make the decision below, the employee must be above 70% of their peers in transactions and over 38% in OppVol. If they exceed both metrics, then the employee does not deserve the bonus.
Did Employee #1 deserve the bonus?
Did Employee #2 deserve the bonus?
Did Employee #3 deserve the bonus?
Did Employee #4 deserve the bonus?
Did Employee #5 deserve the bonus?
Did Employee #6 deserve the bonus?
Did the majority of the employees from the sample deserve the bonus?
| Employee No. | Employee Name | Transaction | Z-Value | Area | Status | oppVol | Z-value | Area | Status |
| 1 | MD | 81 | 0.286182414 | 0.612631 | Above 61.4% of his peers | 52 | -0.8709539 | 0.19188967 | Above 19.2% of his peers |
| 2 | MM | 82 | 0.340797378 | 0.633372 | Above 63.3% of his peers | 30 | -0.9265445 | 0.17708153 | Above 17.7% of his peers |
| 3 | L. Mckinnon | 86 | 0.559257236 | 0.712007 | Above 71.2% of his peers | 861 | 1.17326595 | 0.87965541 | Above 87.9% of his peers |
| 4 | C. Endsoy | 88 | 0.668487165 | 0.748089 | Above 75.4% of his peers | 173 | -0.5652053 | 0.28596706 | Above 28.6% of his peers |
| 5 | A. Reda | 95 | 1.050791917 | 0.853323 | Above 85.3% of his peers | 258 | -0.3504232 | 0.36301054 | Above 36.3% of his peers |
| 6 | T. Dixon | 96 | 1.105406881 | 0.865508 | Above 86.4% of his peers | 1050 | 1.65084018 | 0.95061439 | Above 95.1% of his peers |
Solution
Out of 6 employees there are 2 employees who met both conditions. Employee # 3: Above 71.2% in transaction and 87.9% in Oppval and Employee # 6: Above 86.6% in transaction and 95.1% in Oppval. So employee number 3 and employee number 6 are not deserve for bonus.
And employee number 1, 2, 4 amd 5 deserve bonus.
Yes out of 6, 4 deserve bonus. So majority of the employees from the sample deserve the bonus.

