See attached.
For each question, you will: (4 points for each question): correctly and thoroughly respond to the question, provide appropriate examples as required, and demonstrate an understating of the subject matter of the question.
You will also ensure writing mechanics (2 points): Demonstrate knowledge and use of writing mechanics to enhance the readability.
Finally, you will provide support for responses (2 points): Uses professional sources to support responses. Cites sources using good APA style. Place all responses into a single Word document for submission.
Click on the following document to access the data for this exercise: *HRM 4150 Data for M6-8.xlsxPreview the document
Focusing on the “March” data only, answer the following questions:
1. What is the formula to calculate “Average Acceptance Rate?” What was Joe’s Average Acceptance Rate for March? What was the overall department’s average (all recruiters)? What does this indicate?
2. What is the formula to calculate “Average Candidates per Hire?” What was Carly’s Average Candidates per Hire for March? What was the overall department’s average (all recruiters)? What does this indicate?
3. What is the formula to calculate “Average Time to Hire (days)?” What was Sam’s Average Time to Hire (days) for March? What was the overall department’s average (all recruiters)? What does this indicate?
4. What is the formula to calculate “Average Applicants per Hire?” What was Molly’s Average Applicants per Hire for March? What was the overall department’s average (all recruiters)? What does this indicate?