Good morning, I have the below question that I need answered, hopefully today.

Good morning,

I have the below question that I need answered, hopefully today. I am able to complete these types of questions but am doing something wrong and when I ask for critique so I can know what I am doing wrong I am just told to use a different formula than the one I am using. So long story short can you please complete the below exercise (showing the work and answers) so I can see where I am making my mistake? Thank you!

 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 90-110. 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.

Employee  Name  Transaction z-score OppVol z-score

1.       A. Reda         95    658

2.        T. Dixon   96                      1050

3.           D. Arias 101               653

4.      M. Clarke 104     659

5.    J. Santiago105               895

6.     M. Scott 109              1316

For Transaction, use the mean 39.67 and the standard deviation 9.05.

For OppVol, use the mean 695.86 and the standard deviation 300.80.

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.

1.    Did Employee #1 deserve the bonus?

2.    Did Employee #2 deserve the bonus?

3.    Did Employee #3 deserve the bonus?

4.    Did Employee #4 deserve the bonus?

5.    Did Employee #5 deserve the bonus?

6.    Did Employee #6 deserve the bonus?

Did the majority of the employees from the sample deserve the bonus? If yes, you won