Finding a z Value for a Given Probability
Use Excel’s function options to find the following z values for the standard normal variable Z.
1.) P(Z<z)=0.120 Determine the z score that will produce the probability in statement. Finding a z Value for a Given Probability
Use Excel’s function options to find the following z values for the standard normal variable Z.
2. P(z<Z<0)=0.1172 Determine the z score that will produce the probability in statement
3. P(Z>z)=0.9929 Determine the z score that will produce the probability in statement
. P(0.40<Z<z)0.3368
4. P(Z<0.40)=a Determine the probability z score being less than 0.40
5. a+0.3368 Detrmine the probability of Z being less than z
6.) P(Z<z)=a+0.3368 Determine the z score the Z score were the probability to the left of the value is c16(hint C16 is number 5)
please giv step step by and the excel formula that is used!