For this assignment, you'll start with a spreadsheet of performance ratings for employees who report up through the corporate HR department for a large organization. The performance ratings are on a $1-5$ scale and you can see the ratings from the different sources. Not all employees will have a subordinate group of ratings, because not all of the employees have direct reports.

About the data:

Employee ID is given instead of name

Manager name is given; employees can be grouped by manager

Department name is given; employees can be grouped by managers. Some departments have more than one manager that employees report up through

Manager rating, on a $1-5$ scale

Ratings from $3$ different peers on a $1-5$ scale

Ratings from $3$ different subordinates, on a $1-5$ scale

Not available for all employees

Self rating, on a $1-5$ scale

The organization suggests most employees will be about a $3$ if they are doing what they are supposed to$.$ Being under a $3$ generally warrants follow$-$up$.$ Scores over $3$ are meant to be reserved for above average performance. Distributions are not enforced.

The scores given are an average of $9$ different performance items. What is being show is the average of the items for each rater, not each individual item.

Please complete the following for your assignment:

Create average scores for each employee $($each row of data$)$

Average together the peer ratings for an overall peer rating

Average together subordinate ratings

Average together ALL ratings as a measure of overall performance

Average together ALL BUT SELF ratings as an additional indicator of overall performance.

Note. This can be done in Excel or Jamovi, your choice.

After creating the averages above for each employee $($row of data$)$:

Find the average for each column of data $($that is$,$ what is the average manager rating of performance, across employees$).$ Which category has the highest average? Which has the lowest?

For the manager rating of performance, do there are appear to be differences by department? Comment on which departments seem to have the highest manager ratings of performance and which seem to have the lowest.

Note. Again, you can use Excel to find these averages, or Jamovi. Either program can produce a table $($or Pivot Table in the case of Excel$)$ for you showing average manager ratings by department. You do not need to perform a statistical test at this point.

Finally, determine the correlations between each rater source. Use manager rating, average peer rating, average subordinate rating, and self rating. Would you describe these ratings as weak $(<\mathrm{.}30),$ moderate $($between $\mathrm{.}30-\mathrm{.}60)$ or strong $(>\mathrm{.}60)?$ Is the consistency $($or lack thereof$)$ a good thing or a bad thing and why?

Note. This step is easier in Jamovi. Excel is also capable of finding correlations though.