Hiring Process Analytics
Statistics
Avish Gumber
Trainity project 4
Hiring
Project description
The hiring process is the foundational
and crucial part of a business. The MNCs
learn about the key underlying trends
process relating to the hiring process here. Before
hiring freshmen or anybody else, a
corporation should consider trends such
analytics
as the number of rejections, interviews,
sorts of jobs, openings, etc.
Approach
I imported the data records and prior hirings into
Excel after carefully reading the directions and
taking into account the facts that the team actually
needed in order to obtain a deeper grasp of it. From
there, I discovered the information the team would
require to complete their hiring process and provide
answers to specific queries using the data.
Tech-Stack Used
I used excel 2016 version
Insights
I used a number of Excel formulas to generate the insights,
and working on this project helped me how to use Excel for
professional reasons. I also gained more knowledge on
how an Excel pivot table functions. The data provided
regarding hiring process analytics seemed understandable
to me. A corporation should carefully consider a lot of
trends before employing freshmen or anybody else,
including the frequency of rejections, interviews, job
categories, and vacancies that I discovered.
A. Hiring: Process of intaking of people into an organization for
different kinds of positions.
task : How many males and females are Hired?
Row Labels Count of Status
Female 1854
Male 2557
Grand Total 4411
B.Average Salary: Adding all the salaries for a select group of
employees and then dividing the sum by the number of employees
in the group
task: What is the average salary offered in this company ?
Average salary offered by company
49983
C. Class Intervals: The class interval is the difference between
the upper class limit and the lower class limit.
task: Draw the class intervals for salary in the company ?
Row Labels Count of Post Name
100-10099 686
10100-20099 728
20100-30099 711
30100-40099 713
40100-50099 777
50100-60099 754
60100-70099 698
70100-80099 733
80100-90099 716
90100-100099 649
190100-200099 1
290100-300099 1
390100-400099 1
Grand Total 7168
class interval of salary
900
800
700
600
500
400
frequency
300
200 Total
100
0
0 99 0 99 0 99 0 99 0 99 0 99 0 99 0 99 0 99 0 99 0 99 0 99 0 99
10 20 30 40 50 60 70 80 90 00 00 00 00
0- 0 0- 0 0- 0- 0 0- 0 0- 0- 0- 0 0- 0-
1
0-
2
0-
3
0-
4
10 1 1 1 0 1 1 1 0 1 0 1 0 0 0 0
10 20 30 40 50 60 70 80 9 01 01 01 01
19 29 39
salary
D. Charts and Plots: This is one of the most important part of
analysis to visualize the data.
task: Draw Pie Chart / Bar Graph ( or any other graph ) to show
proportion of people working different department ?
Status Hired
department Count of Status
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
Grand Total 4697
People working in different departments
113 7
0
176
202
1332 Finance Department
General Management
Human Resource Department
Marketing Department
Operations Department
Production Department
Purchase Department
1843
485 Sales Department
Service Department
230
246
E.Charts: Use different charts and graphs to perform the task
representing the data.
task: Represent different post tiers using chart/graph?
Department (All)
Status (All)
Post Name Count of Status
b9 463
c-10 232
c5 1747
c8 320
c9 1792
i1 222
i4 88
i5 787
i6 527
i7 982
m6 3
m7 1
n10 1
n6 1
n9 1
Different post tiers in a company
2000
1800
1600
1400
1200
1000
800
600
400
200
0
b9 c-10 c5 c8 c9 i1 i4 i5 i6 i7 m6 m7 n10 n6 n9
Excel file -
https://docs.google.com/spreadsheets/d/1Vn21sXm1afCMosbvQpSqs7m5Gm1zWwE
M/edit?usp=sharing&ouid=101884962424522246906&rtpof=true&sd=true
