Periodically, it is good business practice to perform a comparative analysis of select groups of employees against published or calculated norms of similar groups in the marketplace. This analysis can justify actions that will preserve employee satisfaction, promote productivity, and prevent attrition.
The CEO has asked for a market analysis of the salary levels of the software analysts in the company. A linear correlation has been found between the number of trouble calls taken by software analysts and their salaries. The equation for this correlation is expressed as follows:
S = 545X + 36,400
In this equation, X is the number of trouble calls handled weekly by a software analyst, and S is the annual salary of the software analyst. The equation for the annual income to offset the software analyst salary is as follows:
I = 2,340X
In this equation, X is the number of trouble calls handled weekly by software analysts, and I is the annual income for subsidizing the software analyst salary.
Part 1: Create a Microsoft Excel spreadsheet with any single worksheet, and perform the following steps:
Part 2: Using text labels, indicate the following information on the graph: