Please use Excel to solve this problem and submit your Excel file. The problem is as follows.

Solve this problem in Excel using a format in Video 2-6. Hahn Engineering is planning on bidding on a job and often competes against a major competitor, Sweigart and Associates (S&A), as well as other firms. Historically, S&A has bid for the same jobs 80% of the time; thus the probability that S&A will bid on this job is 0.80. If S&A bids on a job, the probability that Hahn Engineering will win it is 0.30. If S&A does not bid on a job, the probability that Hahn will win the bid is 0.60. (a) Find the probability that Hahn Engineering will win the bid. (b) If they do, what is the probability that S&A did bid on it.

You may start with a conditional probability table which collects the information from the problem statement. Then generate a joint probability table in which you can the answer to question a. In the end, create posterior probability table in which you can find the answer to question b. Although not required, I also encourage you to use total probably formula and Bayes Rule to compute answers to questions a and b, respectively.

Please use excel for the answer.