Skip to content

PiyushG0999/Hiring-Process-Analytics

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 

Repository files navigation

Hiring-Process-Analytics

Statistics Using Excel

###Hiring process is the fundamental and the most important function of a company. Here, the MNCs get to know about the major underlying trends about the hiring process. Trends such as- number of rejections, number of interviews, types of jobs, vacancies etc. are important for a company to analyse before hiring freshers or any other individual. Thus, making an opportunity for a Data Analyst job here too!

###Being a Data Analyst, your job is to go through these trends and draw insights out of it for hiring department to work upon.

###You are working for a MNC such as Google as a lead Data Analyst and the company has provided with the data records of their previous hirings and have asked you to answer certain questions making sense out of that data.

###After downloading the dataset, use Excel or Google Sheets to answer the below questions:

  1. Hiring: Process of intaking of people into an organization for different kinds of positions.
    • Your task: How many males and females are Hired ?
  2. 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.
    • Your task: What is the average salary offered in this company ?
  3. Class Intervals: The class interval is the difference between the upper class limit and the lower class limit.
    • Your task: Draw the class intervals for salary in the company ?
  4. Charts and Plots: This is one of the most important part of analysis to visualize the data.
    • Your task: Draw Pie Chart / Bar Graph ( or any other graph ) to show proportion of people working different department ?
  5. Charts: Use different charts and graphs to perform the task representing the data.
    • Your task: Represent different post tiers using chart/graph?