Question

In: Math

***PLEASE SHOW HOW TO SOLVE IN EXCEL*** NOT HANDWRITTEN 7) For borrowers with good credit scores,...

***PLEASE SHOW HOW TO SOLVE IN EXCEL*** NOT HANDWRITTEN

7) For borrowers with good credit scores, the mean debt for revolving and installment accounts is $15,015. Assume the standard deviation is $3,540 and that debt amounts are normally distributed.

a. What is the probability that the debt for a borrower with good credit is more than $18,000?

b. What is the probability that the debt for a borrower with good credit is less than $10,000?

c. What is the probability that the debt for a borrower with good credit is between $12,000 and $18,000?

d. What is the probability that the debt for a borrower with good credit is no more than $14,000?

Solutions

Expert Solution

Given that mean = 15015 and standard deviation = 3540

(A) To find P(x>18000)

we can P(X>18000) =1 - P(x<18000)

using excel function NORMDIST(x,mean,sd, cumulative)

put x = 18000, mean = 15015 and standard deviation = 3540 and cumulative = TRUE

we get

P(X>18000) =1 - NORMDIST(18000,15015,3540,TRUE)

= 0.1996

(B)

To find P(x<10000)

using excel function NORMDIST(x,mean,sd, cumulative)

put x = 10000, mean = 15015 and standard deviation = 3540 and cumulative = TRUE

we get

P(X<10000) =NORMDIST(10000,15015,3540,TRUE)

= 0.0783

(C)

To find P(12000<x<18000)

using excel function NORMDIST(x,mean,sd, cumulative)

put x = 12000 and y = 18000, mean = 15015 and standard deviation = 3540 and cumulative = TRUE

we get

P(x<X<y) =NORMDIST(y,mean,sd,TRUE)-NORMDIST(x,mean,sd,TRUE)

this implies

P(12000<x<18000) = NORMDIST(18000,15015,3540,TRUE) - NORMDIST(12000,15015,3540,TRUE)

= 0.6033

(D)

To find P(x<14000)

using excel function NORMDIST(x,mean,sd, cumulative)

put x = 14000, mean = 15015 and standard deviation = 3540 and cumulative = TRUE

we get

P(X<14000) =NORMDIST(14000,15015,3540,TRUE)

= 0.3872


Related Solutions

***PLEASE SHOW HOW TO SOLVE IN EXCEL*** NOT HANDWRITTEN 6) The time needed to complete a...
***PLEASE SHOW HOW TO SOLVE IN EXCEL*** NOT HANDWRITTEN 6) The time needed to complete a final examination in a particular college course is normally distributed with a mean of 90 minutes and a standard deviation of 15 minutes. Answer the following questions. a. What is the probability of completing the exam in one hour or less? b. What is the probability that a student will complete the exam in more than 60 minutes but less than 105 minutes? c....
***PLEASE SHOW HOW TO SOLVE IN EXCEL*** NOT HANDWRITTEN Given that z is a standard normal...
***PLEASE SHOW HOW TO SOLVE IN EXCEL*** NOT HANDWRITTEN Given that z is a standard normal random variable, find z for each situation. a. The area to the left of z is .9750. b. The area between 0 and z is .4750. c. The area to the left of z is .7291. d. The area to the right of z is .1314. e. The area to the left of z is .6700. f. The area to the right of z...
***PLEASE SHOW HOW TO SOLVE IN EXCEL*** NOT HANDWRITTEN 5) The letter grades on the midterm...
***PLEASE SHOW HOW TO SOLVE IN EXCEL*** NOT HANDWRITTEN 5) The letter grades on the midterm exam given in a large managerial statistics class are normally distributed with mean 75 and standard deviation 9. The instructor of this class wants to assign an A grade to the top 10% of the scores, a B grade to the next 10% of the scores, a C grade to the next 10% of the scores, a D grade to the next 10% of...
How can I solve this in Excel? Please show how to solve it in excel step...
How can I solve this in Excel? Please show how to solve it in excel step by step. 1) Speedy Wheels is a wholesale distributor of bicycles for the western United States. Its Inventory Manager, Ricky Sapolo, is currently reviewing the inventory policy for one popular model — a small, one-speed girl's bicycle that is selling at the rate of 250 per month. The administrative cost for placing an order for this model from the manufacturer is $200 and the...
For borrowers with good credit scores, the mean debt for revolving and installment accounts is $15,015....
For borrowers with good credit scores, the mean debt for revolving and installment accounts is $15,015. Assume the standard deviation is $3,540 and that debt amounts are normally distributed. What is the probability that the debt for a borrower with good credit is more than $18,000? What is the probability that the debt for a borrower with good credit is less than $10,000? What is the probability that the debt for a borrower with good credit is between $12,000 and...
For borrowers with good credit scores, the mean debt for revolving and installment accounts is $15,015....
For borrowers with good credit scores, the mean debt for revolving and installment accounts is $15,015. Assume the standard deviation is $3,540 and that debt amounts are normally distributed. What is the probability that the debt for a borrower with good credit is more than $18,000? What is the probability that the debt for a borrower with good credit is less than $10,000? What is the probability that the debt for a borrower with good credit is between $12,000 and...
Please solve handwritten, no Excel. A company purchased new casting equipment at a cost of $250,000....
Please solve handwritten, no Excel. A company purchased new casting equipment at a cost of $250,000. The company also paid an extra $70,000 in necessary costs to have the equipment delivered and installed. The casting machine has an estimated service life of 10 years, and it will be depreciated at a CCA rate = 25%. a] What is the Cost Basis of the casting equipment? b] What will be the CCA amount each year for the service life of the...
PLEASE SHOW HOW TO SOLVE IN EXCEL SHOW STEPS Refer to the Johnson Filtration problem introduced...
PLEASE SHOW HOW TO SOLVE IN EXCEL SHOW STEPS Refer to the Johnson Filtration problem introduced in this section. Suppose that in addition to information on the number of months since the machine was serviced and whether a mechanical or an electrical repair was necessary, the managers obtained a list showing which repairperson performed the service. The revised data follow. Repair Time in Hours Months Since Last Service Type of Repair Repairperson 2.9 2 Electrical Dave Newton 3 6 Mechanical...
*****SOLVE USING EXCEL AND PLEASE SHOW THE EXCEL COMMANDS THAT ARE USED******** A company is considering...
*****SOLVE USING EXCEL AND PLEASE SHOW THE EXCEL COMMANDS THAT ARE USED******** A company is considering the purchase of a new machine that will enable it to increase its expected sales. The machine will have a price of $100,000.  In addition, the machine must be installed and tested.  The costs of installation and testing will amount to $10,000.  The machine will be depreciated using 3-years MACRS. (Use MACRS table from class excel exercise by copying the table and pasting it)          The equipment will...
Please show how to solve this with excel Jane's Sub Shop is considering investing in toaster...
Please show how to solve this with excel Jane's Sub Shop is considering investing in toaster ovens for each of its 120 stores located in the southwestern United States. The high-capacity conveyor toaster ovens, manufactured by Lincoln, will require an initial investment of $15,000 per store plus $500 in installation costs, for a total investment of $1,860,000. The new capital (including the costs for installation) will be depreciated over five years using straight-line depreciation toward a zero salvage value. Jane...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT