Question

Question 1:

PLEASE SOLVE USING EXCEL FUNCTIONS

A professor, transferred from Toronto to New York, needs to sell his house in Toronto quickly. Someone has offered to buy his house for $220,000, but the offer expires at the end of the week. The professor does not currently have a better offer but can afford to leave the house on the market for another month. From conversations with his realtor, the professor believes the price he will get by leaving the house on the market for another month is uniformly distributed between $210,000 and $235,000.

a)If he leaves the house on the market for another month, what is the probability that he will get at least $225,000 for the house?

b)If he leaves it on the market for another month, what is the probability he will get less than $217,000?

c)What is the expeted value and standard deviation of the house price if it is left in the market?

Answer 1