1 of 15

Hiring Process Analytics��Data Analytics Trainee��Name – Shashank Pratap Singh Chandel��Email- Shashankpratapchandel@gmail.com

2 of 15

Analysis done on the following points:-

  1. Hiring: Process of intaking of people into an organization for different kinds of positions.�Your task: How many males and females are Hired ?

​

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.�Your task: What is the average salary offered in this company ?

​

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

​

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

​

E. Charts: Use different charts and graphs to perform the task representing the data.�Your task: Represent different post tiers using chart/graph?

​

3 of 15

Hiring

  1. Hiring: Process of intaking of people into an organization for different kinds of positions.�Your task: How many males and females are Hired ?

4 of 15

Average Salary

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.

Your task: What is the average salary offered in this company ? To find the average salary offered in this company:-

​

To find the average salary we use the formula-

​

=AVERAGE(G2:G7169)

​

OUTPUT –

​

49983.02902

5 of 15

Class Intervals

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

Class Interval for salary in the company for all (Hired + Rejeceted)

6 of 15

Charts and Plots

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

​

​

7 of 15

Charts and Plots

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

* Pie Chart

8 of 15

Charts and Plots

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

* Bar Graph

9 of 15

Charts (Hired + Rejected)

E. Charts: Use different charts and graphs to perform the task representing the data.�Your task: Represent different post tiers using chart/graph?

10 of 15

Charts

E. Charts: Use different charts and graphs to perform the task representing the data.�Your task: Represent different post tiers using chart/graph?

11 of 15

Charts

E. Charts: Use different charts and graphs to perform the task representing the data.�Your task: Represent different post tiers using chart/graph?

12 of 15

Charts (Only Hired )

E. Charts: Use different charts and graphs to perform the task representing the data.�Your task: Represent different post tiers using chart/graph?

13 of 15

Charts (Only Hired )

E. Charts: Use different charts and graphs to perform the task representing the data.�Your task: Represent different post tiers using chart/graph?

14 of 15

Charts (Only Hired )

E. Charts: Use different charts and graphs to perform the task representing the data.�Your task: Represent different post tiers using chart/graph?

15 of 15

Thank You