Question

The personnel department of ZTel, a large communications company, is reconsidering its hiring policy. Each applicant for a job must take a standard exam, and the hire or no-hire decision depends at least in part on the result of the exam. The scores of all applicants have been examined closely. They are approximately normally distributed with mean 500 and standard deviation 50. The current hiring policy occurs in two phases. The 1st phase separates all applicants into three categories: automatic accepts, automatic rejects, and maybes. The automatic accepts are those whose test scores are 600 or above. The automatic rejects are those whose test scores are 420 or below. All other applicants (the maybes) are passed on to a 2nd phase where their previous job experience, special talents, and other factors are used as hiring criteria. To calculate the percentage of applicants who are automatic accepts, given the current standards, which of the following functions should be entered in EXCEL?

Answer 1

we have given : mean = 500 and standard deviation = 50

The current hiring policy occurs in two phases. The 1st phase separates all applicants into three categories: automatic accepts, automatic rejects, and maybes.

The automatic accepts are those whose test scores are 600 or above.

The automatic rejects are those whose test scores are 420 or below.

# Q ) To calculate the percentage of applicants who are automatic accepts, given the current standards, which of the following functions should be entered in EXCEL?

= Excel function : NORMDIST(x , mean , sd , cumulative)

here we have to find out probabilty for greater equal : > = 600

so we can use here = 1 - NORMDIST(600 , 500 , 50 , TRUE)

= 1 - 0.9772 = 0.02275

that is 2.275 %

2.275  percentage of applicants who are automatic accepts, given the current standard.