Prepare a microsoft excel spreadsheet with any single

Assignment Help Computer Engineering

Reference no: EM13466327

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:

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.

Reference no: EM13466327

Questions Cloud

Write a paper of no more than 700 words in which you : write a paper of no more than 700 words in which you compare and contrast the traditional litigation system with the

Consider each of the following forms of business sole : consider each of the following forms of business sole proprietorship partnership limited liability partnership limited

Much of the oral communication which goes on in business is : much of the oral communication that goes on in business is the informal person-to-person communication that occurs

Compare and contrast common law contracts and the ucc : compare and contrast common law contracts and the ucc article 2 with your team. your discussion should include the

Prepare a microsoft excel spreadsheet with any single : periodically it is good business practice to perform a comparative analysis of select groups of employees against

Modern life in walden bartleby the scrivener and life in : thoreau melville and davis might seem to be an odd grouping at first but consider the criticism these writers offer of

What are the benefits to commerce of having : what are the benefits to commerce of having shareholders-and other entities that shield their members protected from

Business intelligence knowledge management and expert : business intelligence and knowledge managementbusiness intelligence knowledge management and expert systems are

Intellectual property as you continue to screen venture : market analysis identify three sources of data for your market research about your business idea and the industry. how

User Account

All Pages