Computer Exercises. For the following problems, show complete manual solutions, and copy (Ctri-C) and paste (Ctri-V) the Excel computer solution BELOW the manual solution, showing the final answer in decimal form, and the syntax/command used, like how It is demonstrated here. The following format is prescribed (example only): Problem No. 1 is the sample Excel solution for the binomial problem on "theft due to buying drugs", as demonstrated in class. 0.250282 is the answer to P(Y = 7) 0.220619 is the answer to P(4 S Y $ 6) 0.525593 is the answer to P(Y > 8) Problem No. 1 ANSWER SYNTAX 0.250282 =BINOM.DIST(7.10,0.75,0) 0.220619 =BINOM. DIST(6,10,0.75,1) - BINOM.DIST(3,10,0.75,1) 0.525593 =1 - BINOM. DIST(7, 10,0.75,1) IMPORTANT: If you are accumulating several probabilities, you MUST set cumulative to "TRUE (1)" 2. In a certain state in the USA, "irreconcilable differences" is given as the legal reason in 70% of all divorce cases. Find the probability that in the next 20 divorce cases filed in this state, (a) at least 18 will claim "irreconcilable differences" as the reason. (b) exactly 14 will claim "irreconcilable differences" as the reason. (c) Find the mean and variance of the number of divorce cases that cite "irreconcilable differences" as the reason for divorce. [9 points] 3. Two tourists are enjoying the view from San Francisco's Golden Gate Bridge. They have decided to spend some time waiting for ships to pass under the bridge. Suppose that ship arrivals at the Golden Gate (leaving or entering San Francisco Bay) are a Poisson distribution at a mean rate of = 0.4 per hour. a. What is the probability that the tourists will see 2 to 4 ships passing beneath them if they spend 1 hour waiting for the ships? b. What is the probability that the tourists will see at least 2 ships passing beneath them if they spend 30 minutes waiting for the ships? C. What is the probability that the tourists will see at most 3 ships passing beneath them if they spend 2 hours waiting for the ships? [9 points]