The performance rating given to a manager at an organization is frequently a basis for that manager’s promotion opportunities, perceived value to the organization, and, sometimes, even that manager’s salary raise. Suppose that you want to study the relationship between the number of years of relevant business experience of a manager, the number of undergraduate or graduate degrees earned by that manager, and that manager’s performance rating (rated on a scale where 1¼Poor and 7¼Excellent) at a large, high-tech company. You decide to test your Excel skills on a small sample of mid-level managers at your company to study this relationship.

These hypothetical data appear in Fig. 7.12.

(a) create an Excel spreadsheet using PERFORMANCE RATING as the criterion, and both the number of years of relevant business experience and the number of undergraduate/graduate degrees earned by the manager as the predictors.

(b) Save the file as: Performance2

(c) Use Excel’s multiple regression function to find the relationship between these three variables and place the SUMMARY OUTPUT below the table.

(d) Use number format (two decimal places) for the multiple correlation, and four decimals for the y-intercept, EXPERIENCE, and NO. DEGREES coefficients on the SUMMARY OUTPUT. Use number format (three decimal places) for the other decimal figures in the SUMMARY OUTPUT.

(e) Print the table and regression results below the table so that they fit onto one page.

(f) Now, go back to your Excel file and create a correlation matrix for these three variables, and place it underneath the SUMMARY OUTPUT on your spreadsheet.
(g) Save this file as: Performance3 (h) Now, print out just this correlation matrix on a separate sheet of paper.