Question

PLEASE PROVIDE EXCEL FORMULA for A-D. I have the answer, I need the formula set up!!!!...

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!!

Homework Answers

Answer #1

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:

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
See below. I have the excel formula for a-c, i need to know how to calculate...
See below. I have the excel formula for a-c, i need to know how to calculate d-f in excel. The Wall Street Journal reported that long term Treasury bonds had a mean return of 24.03% in 2008. Assume that the returns for the long term Treasury bonds were distributed as a normal random variable, with a mean of 24.03 and a standard deviation of 10. If you select an individual Treasury bond from this population, what is the probability that...
For the data set shown​ below, complete parts ​(a) through ​(d) below. x 20 30 40...
For the data set shown​ below, complete parts ​(a) through ​(d) below. x 20 30 40 50 60 y 98 95 91 83 68 ​(a) Use technology to find the estimates of β0 and β1. ANSWER: β0≈b=115.80 ​(Round to two decimal places as​ needed.) β1≈b1=−0.720 ​(Round to two decimal places as​ needed.) (b) Use technology to compute the standard​ error, the point estimate for σ. se=_______???? ​(Round to four decimal places as​ needed.) I need help answering this please. Please...
As a hospital admistrator responsible for staffing, I need to schedul the approiate hispital staff members...
As a hospital admistrator responsible for staffing, I need to schedul the approiate hispital staff members in key areas in order to provide proper care. In a recent years, my hospital had 4,320 births. Find the mean number of births per day, then use that result and the Poisson distribution to find the probility that in a day, there are 13 births. Does it appear likely that on any given say? there will be exactly 13 births? If it is...
please explain neat hand writing gets a thumbs Up . 4. Compute the probability of x...
please explain neat hand writing gets a thumbs Up . 4. Compute the probability of x successes using the binomial formula . Round your answers to three decimal places as needed . X = 3 , n=8, p=0.62, P(X) =?? X = 3 n=8, p=0.62, P(X) =??? 5. JOB elimination , in the past year , 13% of Buisness Have eliminated job's . If 9 Buisnesses are selected At random, Finds the probability That atleast 4 have eliminated jobs during...
(PLEASE answer all questions and I will give you a thumbs up!) A small construction crew...
(PLEASE answer all questions and I will give you a thumbs up!) A small construction crew in northwestern Canada is about to start road work on a mining road. The work is not too difficult and it will only take one day. Since this road is in a pretty remote area, not many vehicles drive on it. The amount of daily traffic follows a uniform distribution with daily vehicles ranging from 4 to 15. Given this discrete uniform distribution, what...
Compute​ P(X) using the binomial probability formula. Then determine whether the normal distribution can be used...
Compute​ P(X) using the binomial probability formula. Then determine whether the normal distribution can be used to estimate this probability. If​ so, approximate​ P(X) using the normal distribution and compare the result with the exact probability. nequals44​, pequals0.4​, and Xequals19 For nequals44​, pequals0.4​, and Xequals19​, use the binomial probability formula to find​ P(X). nothing ​(Round to four decimal places as​ needed.) Can the normal distribution be used to approximate this​ probability? A. ​No, because StartRoot np left parenthesis 1 minus...
You may need to use the appropriate appendix table or technology to answer this question. Although...
You may need to use the appropriate appendix table or technology to answer this question. Although studies continue to show smoking leads to significant health problems, 20% of adults in a country smoke. Consider a group of 450 adults. (b)What is the probability that fewer than 80 smoke? Use the normal approximation of the binomial distribution to answer this question. (Round your answer to four decimal places.) (c)What is the probability that from 95 to 100 smoke? Use the normal...
Compute​ P(X) using the binomial probability formula. Then determine whether the normal distribution can be used...
Compute​ P(X) using the binomial probability formula. Then determine whether the normal distribution can be used to estimate this probability. If​ so, approximate​ P(X) using the normal distribution and compare the result with the exact probability. n=54 p=0.4 and x= 17 For nequals=5454​, pequals=0.40.4​, and Xequals=1717​, use the binomial probability formula to find​ P(X). 0.05010.0501 ​(Round to four decimal places as​ needed.) Can the normal distribution be used to approximate this​ probability? A. ​No, because StartRoot np left parenthesis 1...
You may need to use the appropriate appendix table to answer this question. The time needed...
You may need to use the appropriate appendix table to answer this question. The time needed to complete a final examination in a particular college course is normally distributed with a mean of 80 minutes and a standard deviation of 10 minutes. Answer the following questions. (a)What is the probability of completing the exam in one hour or less? (Round your answer to four decimal places.) (b)What is the probability that a student will complete the exam in more than...
You may need to use the appropriate appendix table or technology to answer this question. Barron's...
You may need to use the appropriate appendix table or technology to answer this question. Barron's reported that the average number of weeks an individual is unemployed is 18.5 weeks. Assume that for the population of all unemployed individuals the population mean length of unemployment is 18.5 weeks and that the population standard deviation is 4 weeks. Suppose you would like to select a sample of 60 unemployed individuals for a follow-up study. (a) Show the sampling distribution of x,...