Hiring Process Analytics.

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

• Solution: Here we have to find the total no of males and females in the organization, so if we are using EXCEL so we have simple formula to count this
• =COUNTIF(D:D,"Male") it will give the result = 4085 , same goes for female
• ==COUNTIF(D:D,“Female") it will give the result =2675.
• And if we want to count both male and females ==COUNTA(D:D) =7169

Case2: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 ?

• Here we can use simple excel formula for calculating the desired result we have to find the median which will tell us the average salary offered by the company
• First we have to count the total sum / total no of people then we will the average salary
• In excel we can find this directly from the ribbon itself

Case4: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 ?

• Charts and plots are very important aspects as sometime we have to visualise the things by looking all the charts and take further decision
• Charts make the things easy to understand but when the data is husge we have to switch accordingly
• In excel we have different types of charts and plots to play with and choose the best chart with tha data.

CHARTS AND PLOTS.

Bar Chart

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

Thank you.