Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The HR department is changing its hiring policy. Currently each applicant must take an exam. Results below the lowest acceptable score are automatically rejected, and

image text in transcribed
The HR department is changing its hiring policy. Currently each applicant must take an exam. Results below the lowest acceptable score are automatically rejected, and scores higher than an automatic acceptance threshold are hired. Those in between are screened using additional techniques and may or may not be hired. The new HR director wants to change the policy so that percentages are used for the automatically accepted and automatically rejected scores. Past experience shows that text results are normally distributed with the mean and standard deviation shown below. Complete the cells so that either score thresholds or percentage threshold could be used. Test Score: Mean Standard Deviation 525 65 Score-based limits: + Automatic acceptance score threshold: 615 Current policy settings Automatic rejection score threshold: 410 Percent accepted: NORM.DIST Percent rejected: Percentage-based limits: Percent accepted: 12% Proposed changes Percent rejected: 10% NORM.INV Automatic acceptance score threshold: use ROUNDUP() to round to zero decimal places Automatic rejection score threshold: use ROUNDDOWN() to round to zero decimal places

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Several Real Variables

Authors: Shmuel Kantorovitz

1st Edition

3319279564, 9783319279565

More Books

Students also viewed these Mathematics questions

Question

What method is used for fitting a logistic regression model?

Answered: 1 week ago