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.

**Assignment**

**Part 1:** Create a Microsoft Excel spreadsheet with any single worksheet, and perform the following steps:

- Name the worksheet FirstInitialLastName_Week3IPa (e.g., MRogers_Week3IPa.xls).
- Create a table with 3 columns. Label the first column "Weekly Trouble Calls - X," the second column "Salary," and the third column "Income."
- In the column labeled "Weekly Trouble Calls," enter numbers from 1 to 50, one number per row.
- Create formulas for the Salary column and Income column to calculate the value of S and I based on the equations above for each of the 50 values of X. Format these 2 columns to be currency, rounded to whole dollars.
- Create a line graph showing the two lines formed by both equations. Add a legend identifying the lines as Salary and Income. Format the axes, if necessary, to avoid a crammed look. For the horizontal axis, specify an interval unit of 5 and choose "Position Axis on Tick Marks" for Windows, and choose "Vertical Axis Crosses Between Categories" for Mac."

**Part 2: **Using text labels, indicate the following information on the graph:

- The break-even point
- The area that represents profit

Subject | Business |

Due By (Pacific Time) | 07/30/2013 12:00 am |

Tutor | Rating |
---|---|

pallavi Chat Now! |
out of 1971 reviews More.. |

amosmm Chat Now! |
out of 766 reviews More.. |

PhyzKyd Chat Now! |
out of 1164 reviews More.. |

rajdeep77 Chat Now! |
out of 721 reviews More.. |

sctys Chat Now! |
out of 1600 reviews More.. |

sharadgreen Chat Now! |
out of 770 reviews More.. |

topnotcher Chat Now! |
out of 766 reviews More.. |

XXXIAO Chat Now! |
out of 680 reviews More.. |