Assessment 3: HR Policy Recommendation Project (40%) The HR Policy Recommendation Project is an extension of Assignment 2, and will be undertaken individually. Extending the data analysis and...

1 answer below »

View more »
Answered 3 days AfterApr 04, 2021MBS603

Answer To: Assessment 3: HR Policy Recommendation Project (40%) The HR Policy Recommendation Project is an...

Naveen answered on Apr 07 2021
166 Votes
Report-HR analytics
Introduction:
    The data Human Resource Analytics is about the various metric of the each employee like performance, salary, Hiring cost and so on. This data will helpful us to take or recommend the companies to get high profit by using some of the statistical techniques.
    The main aim of this assignment is to give or recommend organization to get the high profit by recruiting the staff.
Here we have various measures of the employee which will help us in modeling and making the relationships between the metrics. This data having the four locations those are Victoria, Brighton, Denver and Eaton. We have the techniques like correlation and regression to get the recommendation to the organization.
    By using the correlation technique we can get to know is there any relationship between the metrics. This relationship will help us to take decisions in the organization. For example if there is relations between the metrics profitability and Hiring cost then we can say that there is effect on profit by the Hiring cost which may be positive effect or negative effect.
    The regression analysis will help us to get the relationship between multiple variables at a time with the dependent or target variable. Here the target variables/metric is profit because the end goal is to improve the profit of organization it will be depend on the various measures of the each employee. If we get the positive effect of some of the metrics on profit then we can suggest that to make some changes in that metric so there by the organization will get the profit as they expect.
The HR analytics data is helpful to get the finding from the organization to make better way to organize the company or the employees. By using the various statistics techniques that is some of the descriptive statistics and inferential statistics those are correlation, regression.
    By using the results or the interpretations from these two techniques we can suggest or make a policy of employees for better running of an organization to get high profit levels.
    In the next steps we will do the above discussed analysis using Excel
Analysis:
Correlation:
    Here we are going to see the relation between the various metrics of the data which will help us to know the effect of each variable on the target metric.
Here we are used the correlation analysis and the regression analysis for making the relationship between the profitability with some of the response variables. Because in correlation analysis it will give us the co-efficient value which means correlation will give us the each pair relation or the strength of the relation. So from here we can get to know that which variable is related with the target variable which is profitability. For each pair it will give the some value that may be by chance. In practical view we can’t get the zero correlation between two variables.
        The correlation between the metrics performance and Hiring cost is 0.2831553 which means there is a chance of 28.13% times performance will increase when we increase the Hiring cost. So, those are having positive relation with each other or the positive effect on the performance by Hiring cost.
    Correlation between the metrics TimeToFill and Hiring cost is 0.304457351 which mean that there is chance of 30.44% Hiring cost will increase by increase of TimeToFill. If the organization will take the more time or days to fill the employee position then it will tend to increase the Hiring cost. It will reduce the profit of the organization. So need to fill the employee position as soon as possible.
     The correlation between the variables or metrics Salary and Productivity is 0.299601124.That is if salary of the employee will increase that means high then there is chance if increasing productivity by 29.96% approximately 30%. So, high paying employees are giving high productivity which is not applicable in all times.
    The correlation between the Salary and Profitability is 0.211263649 which means there is 21.13% of chance increasing profit by increasing salary. It is having week relation which is not significant or...
SOLUTION.PDF

Answer To This Question Is Available To Download

Submit New Assignment

Copy and Paste Your Assignment Here
April
January
February
March
April
May
June
July
August
September
October
November
December
2025
2025
2026
2027
SunMonTueWedThuFriSat
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
00:00
00:30
01:00
01:30
02:00
02:30
03:00
03:30
04:00
04:30
05:00
05:30
06:00
06:30
07:00
07:30
08:00
08:30
09:00
09:30
10:00
10:30
11:00
11:30
12:00
12:30
13:00
13:30
14:00
14:30
15:00
15:30
16:00
16:30
17:00
17:30
18:00
18:30
19:00
19:30
20:00
20:30
21:00
21:30
22:00
22:30
23:00
23:30