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 rejects, given the current standards, which of the following functions should be entered in EXCEL?

Answer 1

Suppose, random variable X denotes score of applicants in the exam in the first phase.

To calculate the percentage of applicants who are automatic rejects, we have to calculate .

To calculate the probability in EXCEL we have to enter the following function.

Here 'TRUE' is used as lower tail is to be calculated.

So, the function to be entered in EXCEL is given by