## Description

### Unformatted Attachment Preview

Purchase answer to see full attachment

## Explanation & Answer

View attached explanation and answer. Let me know if you have any questions.

In any organization, the salaries paid to the different employees differ. There are many factors

that lead to the difference in salaries between employees. It is important to study the relationship

between salaries and these factors to help in building a model that will help in determining

salaries. This paper, therefore, is a report on research done on Datacom to find out the

relationship between salaries and years of previous experience and salaries number of employees

the employee supervises. The question to be answered here is, what is the relationship between

salaries and these factors? What impact do these factors have on the level of salaries?

1

Technical Report

Student's Name

Institution

Course Name

Instructor's Name

Date

2

Introduction

In any organization, the salaries paid to the different employees differ. There are many factors

that lead to the difference in salaries between employees. It is important to study the relationship

between salaries and these factors to help in building a model that will help in determining

salaries (Ross et al,2012). This paper, therefore, is a report on research done on Datacom to find

out the relationship between salaries and years of previous experience and salaries number of

employees the employee supervises. The question to be answered here is, what is the relationship

between salaries and these factors? What impact do these factors have on the level of salaries?

Data Analysis

Descriptive analysis

This section tells us more about the variables that are involved in this study through the results of

their descriptive statistics. This will include the mean, median, standard deviation, and

frequency. The results of the descriptive are as follows.

Salary

The most paid employee receives a total of $69246 while the least paid employee gets

$23654. It can be seen that the difference between the most paid employee and the least paid

employee is $45,592 which can be considered to be a big difference. The mean salary paid to

employees is $39827.39. By definition, the mean is a measure of central tendency that shows the

most common value for a set of numbers (Lee, 2008). The mean is nearer to the highest salary

paid which shows that most of the employees receive high salaries. The median which is the

middle value of a set of numbers arranged in ascending order is $36541.5. Again, this value is

nearer to the highest-paid salary value which means that most of the employees are paid high

3

salaries. The standard deviation which measures the degree of variance of the values from the

mean is 10999.24. The standard deviation tells us how far the values are scattered away from the

mean (Lee, 2015). A high standard deviation means that they are much scattered while a low

standard deviation shows the vice versa.

Years of previous experience

The employee who has the highest period of previous experience has worked for 19years

while the employee with the least previous experience has zero years in previous experience. The

mean number of years of employees’ previous experience is 4.61. This shows most of the

employees at Datacom have worked for approximately four and half years in their previous jobs.

The median number of years of employees’ previous experience is 4. The standard deviation is

3.73 years.

Number of employees supervised

The employee who supervises the highest number of employees supervises 45 employees

while the one that supervises the least number of employees supervises no employee. The mean

number of employees supervised by each employee is six employees. This means that most of

the employees have six employees under their supervision. The median number of employees

under each of the employees supervised is three employees. The standard deviation is 10.

Regression Analysis

Regression analysis is a statistical method that is used to show the relationship between

one variable (dependent variable) and other variables (independent variables) (Seber &

Lee,2012). In our case, we want to find out how employees’ salaries relate to the other factors

(years of previous experience and the number of employees they supervise). Therefore,

4

employees’ salaries will be the dependent variable while the number of years of previous

experience and the number of employees they supervise will be the independent variables.

After running the regression analysis (linear regression) there were three models that

could be used. The first model shows the relationship between the salaries of the employees and

the number of years of previous experience. The second model shows the relationship between

the salaries of the employees and the number of employees that are under the employee’s

supervision. The third model shows the combined relationship between the salaries and these two

independent variables. The results of the analysis were as follows.

Model 1

This model shows the relationship between the salaries of the employees and the number of

years of previous experience. It also shows how the independent variable(X) (number of years of

previous experience affects the dependent va...