Hiring Process Analytics��Data Analytics Trainee��Name – Shashank Pratap Singh Chandel��Email- Shashankpratapchandel@gmail.com
Analysis done on the following points:-
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?
Hiring
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
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)
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 ?
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
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
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?
Charts
E. Charts: Use different charts and graphs to perform the task representing the data.�Your task: Represent different post tiers using chart/graph?
Charts
E. Charts: Use different charts and graphs to perform the task representing the data.�Your task: Represent different post tiers using chart/graph?
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?
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?
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?
Thank You