Question

In: Statistics and Probability

Z is a random normal variable. Find the following z values using excel: a. What is...

Z is a random normal variable. Find the following z values using excel:

a. What is the value of z if the area to the left of z is 0.9515 ?

b. What it the value of z if the area to the left of z is 0.1249 ?

c. What is the value of z if the area to the right of z is 0.33 ?

d. What is the z value such that the area between -z and z is 0.80 ?

Solutions

Expert Solution

a. Excel function :                =NORM.INV(0.9515,0,1)

   Answer :                    1.659575

b. Excel function :                =NORM.INV(0.1249,0,1)

   Answer :                  -1.15084

c. Excel function :      =NORM.INV(0.67,0,1)

   Answer :                 0.439913

d. Excel function :      =NORM.INV(0.9,0,1)

   Answer :                 1.281552

Dear student,

If you find this answer helpful, do provide your valuable feedback through voting and commenting.

orchestra answered 2 years ago
Next > < Previous

Related Solutions

For a random variable Z, that follows a standard normal distribution, find the values of z...
For a random variable Z, that follows a standard normal distribution, find the values of z required for these probability values: P(Z<z)=.5 = P(Z<z)=.1587 = P(Z<z)=.8413 = Please show how to solve without using excel. Please show all steps. Thank you!
Given that Z is a standard normal random variable, find z for each situation using the...
Given that Z is a standard normal random variable, find z for each situation using the Norm.S.Inv function in excel. a. The area to the right of z is .01 b. The area between -z and z is .9030 c. The area between -z and z is .9948 e. The area to the right of z is .025 f. The area to the right of z is .3300
Find the following z values for the standard normal variable Z. (You may find it useful...
Find the following z values for the standard normal variable Z. (You may find it useful to reference the z table. Negative values should be indicated by a minus sign. Round your answers to 3 decimal places.) a. P(Z ≤ z) = 0.1002 b. P(z ≤ Z ≤ 0) = 0.121 c. P(Z > z ) = 0.8204 d. P(0.36 ≤ Z ≤ z) = 0.3458 explain
Find the following z values for the standard normal variable Z. (You may find it useful...
Find the following z values for the standard normal variable Z. (You may find it useful to reference the z table. Negative values should be indicated by a minus sign. Round your answers to 3 decimal places.) a. P(Z ≤ z) = 0.1002 b. P(z ≤ Z ≤ 0) = 0.121 c. P(Z > z ) = 0.8204 d. P(0.36 ≤ Z ≤ z) = 0.3458 explain
Find the following z values for the standard normal variable Z. Use Table 1. (Negative values...
Find the following z values for the standard normal variable Z. Use Table 1. (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.)   a. P(Z ≤ z) = 0.1105   b. P(z ≤ Z ≤ 0) = 0.1607   c. P(Z > z ) = 0.7698   d. P(0.25 ≤ Z ≤ z) = 0.3428
Calculate the probability For the standard normal distribution random variable Z using Excel formulae/functions. P (Z...
Calculate the probability For the standard normal distribution random variable Z using Excel formulae/functions. P (Z ≤ 2) P (-1.63 < Z ≤ 1.95) P (-1 < Z < 1) P (Z ≤ -0.69) P (0.85 < Z ≤ 2.23) P (Z > 3)
1. Suppose a random variable, Z, follows a Standard Normal distribution. Find the following probabilities using...
1. Suppose a random variable, Z, follows a Standard Normal distribution. Find the following probabilities using the z-table.   For the Z distribution, find the following. Use z-table and check with Excel. Sketch, etc.             (a) the 28th percentile             (b) the 59th percentile.
If Z is a standard normal random variable, find the value z0 for the following probabilities....
If Z is a standard normal random variable, find the value z0 for the following probabilities. (Round your answers to two decimal places.) (a) P(Z > z0) = 0.5 z0 = (b) P(Z < z0) = 0.9279 z0 = (c) P(−z0 < Z < z0) = 0.90 z0 = (d) P(−z0 < Z < z0) = 0.99 z0 =
Find the following probability for a standard normal random variable, P(Z ≥ -2.16 )
Find the following probability for a standard normal random variable, P(Z ≥ -2.16 )
Given that z is a standard normal random variable, find z for each situation.
  Given that z is a standard normal random variable, find z for each situation. (Round your answers to two decimal places.) (a) The area to the left of z is 0.2119. (b) The area between −z and z is 0.9398. (c) The area between −z and z is 0.2052. (d) The area to the left of z is 0.9949. (e) The area to the right of z is 0.5793.
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT