UT The Salaries Paid to The Different Employees Differ Report

User Generated

Ebqev21

Business Finance

University of Toronto

Description

Unformatted Attachment Preview

Individual Coursework This coursework requires to submit a technical report (1,500 words) that discusses the managerial problem, the results, their implications and makes recommendations for improvement. Please upload your coursework to Moodle by the deadline. I. Specific Instructions You will be assigned a data in EXCEL format. Based on this data, you are required to identify a management decision problem or a research question – that can be addressed using the variables in the data. You can use Excel (or other software such as SPSS) to conduct an analytic for the problem, elaboration on the results, and make managerial implications. Your coursework will be marked according to the following criteria: 1. Description of the management decision problem; 2. Application of analytics theory and techniques; 3. Discussions on the result; 4. Making managerial recommendations. 1. The grade components will be approximately distributed as follows: Introduction (5%) Descriptive analysis (20%) Regression analytics (25%) Managerial interpretations and implications (40%) Conclusion (10%) Introduction In this section, you will identify your research question - based on the Excel Data you are assigned. It is important to give reasons for why you think it’s interesting to explore such question. Descriptive analysis: Import the raw data to the database, make sure it imported correctly, identify the main tables and relationships between, produce relevant visualizations. Regression analysis: Using appropriate regression models to address the managerial problem. II. Steps to be taken 1. Please go to the module webpage in Unihub; 2. Go to the section named “Individual Coursework"; 3. Open the file name “Assignment of Excel file”; 4. Identify the data file (e.g., Data 2) that is associated with your student ID. 5. Click on list of data set; 6. Open the Excel file that you find in step 4. For example, if your student ID is associated with Data 2, then you will work on Data 2. III. Some suggestions on how to proceed with the assignment The best way to think about this assignment is to consider it a simplified version of your master dissertation which you are going to do soon! As such, you can apply knowledge acquired from the Dissertation Module, and any other modules to work on the assignment. In what follows, we would like to provide you with some suggestions on how to explore the EXCEL data to write the report. Let’s assume you are given a data that have information about HR. In this data you have variables such as age, gender, work experience, education, salary, tenure and so on. 1. How to define a management decision problem or research question? It is sufficient to define just one research question. In this example, you can propose a question such as “ Does there exist a link between gender and wage differential?”. In other words, you want to study whether female employees and male employees have the same salary level if they have the same level of education, work experience…. It is also important to elaborate on why you think this is an interesting and relevant question. To do so, it’s a good idea to incorporate some existing academic references that address the link between gender and salary. 2. 2.1. How to do the data analysis Descriptive analysis You can report some measure of central tendency such as mean, median, standard deviation, frequency of the main variables in the Excel file; 2.2. Regression analysis In this example, salary would be the dependent variable. You then can run the regression using the analytics tools and techniques we talk in class. 3. Interpretation of the results It’s important to provide some discussion on your findings. For example, if you find that the coefficient for men is positive i.e., men have higher salary than women. You can explain why this might be the case. Also, it’s good idea to make references to academic studies that may or may not support your results. 4. Recommendation What would be the managerial implications for your results? For example, if men have higher salary then women, what would you like to recommend either from the government’s policy perspective, and/or from the firm’s HR practices perspective. ID number Data M00649553 8 M00657549 8 M00659000 3 M00684886 8 M00686977 9 M00670791 9 M00693889 7 M00671784 5 M00737781 9 M00740146 2 M00784058 8 M00339590 8 M00814787 6 M00835462 3 M00797489 4 M00804107 6 M00806730 9 M00830990 9 M00814776 3 M00782686 2 M00828526 1 M00824481 1 M00831193 8 M00826779 4 M00777046 2 M00838438 5 M00689409 6 M00829570 6 M00824878 7 M00839311 2 M00842969 3 M00839173 1 M00845707 8 M00840499 5 M00838610 4 M00838942 4 M00642575 8 M00837503 8 M00838602 9 M00839679 8 M00841186 1 M00843243 2 M00849988 8 M00838569 9 M00826803 5 M00846050 7 M00643431 6 M00844729 4 M00845855 2 M00848065 7 M00848541 6 M00848561 3 M00848565 7 M00849068 2 M00842721 1 M00849049 2 M00849116 7 M00812834 8 M00848328 9
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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...


Anonymous
Just the thing I needed, saved me a lot of time.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags