1. use excel to answer the following. in each question, find the blank to make the statement true. note that z represents we are using the standard normal distribution. note: round your answers to two decimal places. a) p(z < -0.69) = b) p(z > 1.84) = c) p(z > )= 0.921 d) p(z < ) = 0.61 2. use excel to answer the following. in each question, find the blank to make the statement true. in this example assume we have a variable x that is distributed normally with mean 30 and standard deviation 6. note: round your answers to two decimal places. a) p(x < 28.40) = b) p(x > 39.30) = c) p(x > )= 0.043 d) p(x < ) = 0.086

1. A: 0.25; B: 0.03; C: 1.41; D: -0.28

2. A: 0.39; B: 0.06; C: 40.30; D: 21.81

Step-by-step explanation:

For CDF lookups, we used the Excel NORMDIST(x, mean, stdev, TRUE) function. For inverse CDF lookups, we used the NORMINV(x, mean, stdev) function.

Each of these functions works with the area under the curve from -∞ to x, so for cases where we're interested in the upper tail, we subtract the probability from 1, or subtract the x value from twice the mean.

For question 1, we computed the Z values in each case. The NORMDIST function works directly with x, mean, and standard deviation, so does not need the z value.

b is the final answer! : )

the median here is 25. your lowest value is 14 and highest value is 48. to find the third quartile, find the medium number in between 25 and 48 which would be 42 i believe.