# Project #39363 - Excel

Be sure to download the companion resources using the link provided in the reading assignments.

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.

Assignment

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

1. Name the worksheet FirstInitialLastName_Week3IPa (e.g., MRogers_Week3IPa.xls).
2. Create a table with 3 columns. Label the first column "Weekly Trouble Calls," the second column "Salary," and the third column "Income."
3. In the column labeled "Weekly Trouble Calls," enter numbers from 1 to 50, one number per row.
4. 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.

 Subject Computer Due By (Pacific Time) 09/08/2014 08:00 am
TutorRating
pallavi

Chat Now!

out of 1971 reviews
amosmm

Chat Now!

out of 766 reviews
PhyzKyd

Chat Now!

out of 1164 reviews
rajdeep77

Chat Now!

out of 721 reviews
sctys

Chat Now!

out of 1600 reviews
sharadgreen

Chat Now!

out of 770 reviews
topnotcher

Chat Now!

out of 766 reviews
XXXIAO

Chat Now!

out of 680 reviews
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy