Using Excel, please demonstrate use of functions to solve the following probability problem.
Tired of careless spelling and grammar, a company decides to administer a test to all job applicants. The test consists of 20 sentences. Applicants must state whether each sentence contains any grammar or spelling errors. Half the sentences contain errors. The company requires a score of 14 or more.
If an applicant guesses randomly, what is the probability of passing? (Round your answer to 4 decimal places.)
What minimum score would be required to reduce the probability "passing by guessing" to 5 percent or less?© BrainMass Inc. brainmass.com October 10, 2019, 1:23 am ad1c9bdddf
This solution provides a step-by-step calculations to determine the probability of passing a job application test.