Question

Consider the following set of data on the performance rating of an employee in an organization. The rating is ranging from 0 to 4.

0 - very poor

1 - poor

2 - average

3 - Excellent

4 - Outstanding .

1. Analyze the given data and rank them based on their performance. And give reasons.

2. Analyzing their performance between 2011 and 2017, what can you decide about their performance?

3. If the results of 1 and 2 are different, Explain why.

Year	Rating of Employee X	Rating of Employee Y
2001	3	4
2002	3	1.5
2003	2	2
2004	3	3
2005	3.5	4
2006	2.5	4
2007	3	3
2008	4	2.5
2009	3	2
2010	3.5	2
2011	2	2.5
2012	3	2
2013	1.5	2
2014	2	0.5
2015	1.5	0.5
2016	1.5	3
2017	2	1.5

Answer 1

1)

Rating of Employee X Rating of Employee Y 1 Year 2001 2002 2003 1.5 4 3.5 4 2.5 4 2007 4 2.5 10 2010 2011 2012 2013 2014 2015 2016 2017 3.5 2.5 12 13 14 15 16 17 1.5 0.5 1.5 0.5 1.5 1.5 19

20 21 Mean 22 Standard Deviation 23 Coefficient of Variation 24 Rank 25 2.588235294 0.775308288 29.95509294 2.352941176 1.071866157 45.55431168 2
We have given ranking to the employees based on their performance by using the CoV process.

2)

Rating of Employee X 3.5 2.5 Rating of Employee X 1.5 Linear (Rating of Employee X) 0.5 0 2010 2012 2014 2016 2018

Rating of Employee Y 3.5 2.5 ◆ Rating of Employee Y 1.5 -Linear (Rating of Employee Y) 0.5 0 2010 2012 2014 2016 2018

As it is clearly visible in the above plots that the performance of both the employees has been decreased as the timespan increases.But performance of Y decreases much faster than X(trend shows this)

3) There's not much difference in the above two analysis both of them shows that the performance of X is better than the Y.