Some management trainees across several branches of an electronics store were rated by their customers, and by their bosses. Comment on the correlation between the two sets of ratings. The data are shown in Exhibit 3.52 below. A rating of €œ1€ is excellent, and a rating of €œ5€ is poor. Do the ranking by hand and then use Excel to calculate the Spearman rank correlation coefficient, using the PEARSON function on your assigned ranks. Also, use the add-in for Spearman Rank Correlation Coefficient on the data.

Transcribed Image Text:

Management Trainees' Ratings Ratings by Customers Ratings by Bosses 4. 3. 2 2 4 1 2 3. 4) 2.