The personnel department of ZTel, a large communicationscompany, is reconsidering its hiring policy. Each applicant for ajob must take a standard exam, and the hire or no-hire decisiondepends at least in part on the result of the exam. The scores ofall applicants have been examined closely. They are approximatelynormally distributed with mean 500 and standard deviation 50. Thecurrent hiring policy occurs in two phases. The 1st phase separatesall applicants into three categories: automatic accepts, automaticrejects, and maybes. The automatic accepts are those whose testscores are 600 or above. The automatic rejects are those whose testscores are 420 or below. All other applicants (the maybes) arepassed on to a 2nd phase where their previous job experience,special talents, and other factors are used as hiring criteria. Tocalculate the percentage of applicants who are automatic accepts,given the current standards, which of the following functionsshould be entered in EXCEL?
