Question

In: Math

***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 is .3300.

Solutions

Expert Solution

z is a standard normal variable.

a.The area to the left of z is 0.9750

Therefore,

Z=1.96 ( since using Excels (=NORMSINV(0.9750)))

# calculated value of z for the area value to the left of 0.9750 is 1.96

b. The area between 0 and z is .4750.

ANS

From the information, observe that z is a standard normal variable.

The area between 0 and z is 0.4750

Therefore,

P(0<Z<z)=0.4750

P(Z<z)-P(Z<0)=0.4750

P(Z<z)=P(Z<0)+0.4750

P(Z<z) =0.5+0.4750    ieP(Z<0)=0.5

  P(Z<z)=9750

Therefore,

Z=1.96 ( since using Excels (=NORMSINV(0.9750)))

The calculated value of z for the area between 0 and z is 0.4750 is 1.96

c. The area to the left of z is .7291.

Ans:

From the information, observe that z is a standard normal variable.

The area to the left of z is 0.7291

Therefore,

Z=0.61( since using Excels (=NORMSINV(0.7291)))

# calculated value of z for the area value to the left of 0.7291 is 0.61

d. The area to the right of z is .1314.

Ans:

From the information, observe that z is a standard normal variable.

The area to the right of z is 0.1314

Therefore,

P(Z>z)=0.1314

1-P(Z<z)=0.1314

P(Z<z)=1-0.1314=0.8686

Z=1.12( since using Excels (=NORMSINV(0.8686)))

Therefore,

Part d

The calculated value of z for the area value to the right of 0.1314 is 1.12

e. The area to the left of z is .6700.

Ans:

From the information, observe that z is a standard normal variable.

The area to the left of z is 0.6700

Therefore,

P(Z<z)=0.6700

Z=0.44( since using Excels (=NORMSINV(0.6700)))

Therefore,

Part e

#The calculated value of z for the area value to the left of 0.6700 is 0.44

f. The area to the right of z is .3300.

Ans:

P(Z>z)=0.3300

1-P(Z<z)=0.3300

P(Z<z)=1-0.3300=0.6700

Therefore,

Z=0.44( since using Excels (=NORMSINV(0.6700)))

#The calculated value of z for the area value to the right of 0.3300 is 0.44


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 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...
***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...
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...
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...
Find the probability for Z>-0.97 given that Z is Standard Normal Distribution?
Find the probability for Z>-0.97 given that Z is Standard Normal Distribution?
Find the probability for Z<1.14 given that Z is Standard Normal Distribution?
Find the probability for Z<1.14 given that Z is Standard Normal Distribution?
If Z is Standard Normal Variable, answer the following questions. Please show you complete work for...
If Z is Standard Normal Variable, answer the following questions. Please show you complete work for each question. a. What is the Z value if the area under the curve and to the right of Z is 0.95 b. What is the probability of Z is within the interval of -1.75 and 2.61? c. What are the middle Z values (-Z and + Z) such that the area under the probability curve from -Z to +Z is 0.97?
*****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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT