Project Bidding. Jonah Arkfeld, a building contractor, is preparing a bid on a new construction project. Two other contractors will be submitting bids for the same project. Jonah has analyzed past bidding practices and the requirements of the project to determine the probability distributions of the two competing contractors. The bid from Contractor A can be described with a normal distribution with a a mean of $800,000 and a standard deviation of $50,000. The bid from Contractor B can be described with a normal distribution with a mean of $700,000 and a standard deviation of $50,000.

Create a simulation model based on the Model file Bidding. (1 points)

If Jonah submits a bid of $750,000, what is the probability that he will win the bid for the project? (1 points)

What is the probability that Contractor A and Contractor B will win the bid, respectively? (1 points)

(NOTE: I have already ran the simulation in excel but just need to know what excel function to use to find the probability.)