HIRING PROCESS ANALYTICS
PRACHI RANJAN
PROJECT DESCRIPTION
The project is about finding out valuable insights that can help improve the company’s hiring process. We
analyze this data on the following points:
A. Hiring Analysis
B. Salary Analysis
C. Salary Distribution
D. Departmental Analysis
E. Position Tier Analysis
Software Used:-
• Microsoft Excel 2307
Hiring Analysis: The hiring process involves bringing new individuals
into the organization for various roles.
Task A: Determine the gender distribution of hires. How many males and females have
been hired by the company?
Formula:-
Men : =COUNTIFS(D:D, J38, C:C, K38)
Female : =COUNTIFS(D:D, J39, C:C, K39)
Output:-
event_name Status no_of_male_and_female
Male Hired 2563
Female Hired 1856
Hiring Analysis: The hiring process involves bringing new individuals
into the organization for various roles.
no_of_male_and_female
Female
Hired
Male
Hired
0 500 1000 1500 2000 2500 3000
Salary Analysis: The average salary is calculated by adding up the salaries
of a group of employees and then dividing the total by the number of
employees.
Task B: What is the average salary offered by this company? Use Excel functions to
calculate this.
Formula:-
=AVERAGE(G:G)
Output:-
Average 49983.02902
Salary Distribution: Class intervals represent ranges of values, in this case,
salary ranges. The class interval is the difference between the upper and
lower limits of a class.
Task C: Create class intervals for the salaries in the company. This will help you
understand the salary distribution.
• There are outliers in this Dataset. First we need to remove outliers.
Salary Distribution: Class intervals represent ranges of values, in this case,
salary ranges. The class interval is the difference between the upper and
lower limits of a class.
Salary range for Hired and Rejected (After removing outliers)
450
400
350
300
250
200
150
100
50
0
Salary Distribution: Class intervals represent ranges of values, in this case,
salary ranges. The class interval is the difference between the upper and
lower limits of a class.
Salary range for Hired (After removing outliers)
300
250
200
150
100
50
0
Departmental Analysis: Visualizing data through charts and plots is a
crucial part of data analysis.
Task D: Use a pie chart, bar graph, or any other suitable visualization to show the
proportion of people working in different departments.
Department no_of_people
Finance Department 176
General Management 113
Human Resource Department 70
Marketing Department 202
Operations Department 1843
Production Department 246
Purchase Department 230
Sales Department 485
Service Department 1332
Departmental Analysis: Visualizing data through charts and plots is a
crucial part of data analysis.
General
Management, 113, Human Resource
NO_OF_EMPLOYEE
3% Department, 70, 2%
Marketing
Department, 202, 4%
Service Department,
1332, 29%
Operations
Department, 1843,
41%
Sales Department,
485, 11%
Purchase Production
Department, 230, 5% Department, 246, 5%
Departmental Analysis: Visualizing data through charts and plots is a
crucial part of data analysis.
no_of_employee
SERVICE DEPARTMENT 1332
SALES DEPARTMENT 485
PURCHASE DEPARTMENT 230
PRODUCTION DEPARTMENT 246
OPERATIONS DEPARTMENT 1843
MARKETING DEPARTMENT 202
HUMAN RESOURCE DEPARTMENT 70
GENERAL MANAGEMENT 113
0 200 400 600 800 1000 1200 1400 1600 1800 2000
Position Tier Analysis: Different positions within a company often
have different tiers or levels.
Task E: Use a chart or graph to represent the different position tiers within the
company. This will help you understand the distribution of positions across different
tiers.
Post Name no_of_people_hired
b9 308
c-10 105
c5 1182
c8 193
c9 1239
i1 151
i4 32
i5 511
i6 337
i7 635
m6 2
n6 1
Position Tier Analysis: Different positions within a company often
have different tiers or levels.
no_of_people_hired
1400
1239
1182
1200
1000
800
635
600 511
308 337
400
193
151
200 105
32 2 1
0
b9 c-10 c5 c8 c9 i1 i4 i5 i6 i7 m6 n6
