PLEASE PROVIDE EXCEL FORMULA for A-D. I have the answer, I need the formula set up!!!! I will thumbs up!!
According to the Mortgage Bankers Association, 11% of U.S. mortgages were delinquent in Texas in the second quarter of last year. A delinquent mortgage is one that has missed at least one payment but has not yet gone to foreclosure. A random sample of six mortgages in Texas was selected.
A) What is the probability that exactly one of these mortgages is delinquent? Round to four decimal places as needed.
B) What is the probability that less than three of these mortgages are delinquent? Round to four decimal places as needed.
C)What is the mean of this distribution? Round to two decimal places as needed.
D) What is the standard deviation of this distribution? Round to three decimal places as needed.
PLEASE PROVIDE EXCEL FORMULA for A-D. I have the answers, I need the formula set up!!!! I will thumbs up!!
Solution:
Let x be the number of delinquent mortgages, therefore, the random variable x follows the binomial distribution with n = 6 and p = 0.11
A) The excel formula to find the probability that exactly one of these mortgages is delinquent is:
B) The excel formula to find the probability that less than three of these mortgages are delinquent is:
C) The excel formula to find the mean of this distribution is:
D) The excel formula to find the standard deviation of this distribution is:
Get Answers For Free
Most questions answered within 1 hours.