Answer the following questions and use Excel to showyour work.
A student has an important exam coming up and is contemplatingnot studying for the exam in order to attend a party with hisfriends. The student must earn a minimum score of 70% on the examin order to successfully maintain his desired GPA. Suppose thestudent knows in advance that the exam will consist of 20multiple-choice questions with 4 possible answers for eachquestion. Answer questions 1–3 using the preceding information andmodeling this situation as a binomial distribution.
1. What is the probability that the student will successfullyearn exactly the required minimum score of 70% on the exam basedsolely on randomly guessing the correct answer for each question?a) 2.57 b) 2.57E-02 c) 2.57E-05 d) 2.57E-04
2. What is the probability that the student will earn less thanthe required minimum score of 70% on the exam based solely onrandomly guessing the correct answer for each question? a) 0.74673b) 0.85198 c) 0.99997 d) 0.23499
3. What is the probability that the student will successfullyearn no less than the required minimum score of 70% on the exambased solely on randomly guessing the correct answer for eachquestion? a) 3.51E-04 b) 2.95E-05 c) 6.87E-06 d) 1.27E-03
