Suppose a data set is normally distributed with a mean u = 70 and the population standard deviation a = 10. You want to find the cutoff value (x) for certain areas (p-values) of a normal distribution....

Extracted text: Suppose a data set is normally distributed with a mean u = 70 and the population standard deviation a = 10. You want to find the cutoff value (x) for certain areas (p-values) of a normal distribution. Left area (p 0.09) In cell B3 type: =NORM.INV(0.09,70,10) Right area (p= 0.09) In cell B4 type: =NORM.INV(0.91,70,10) Middle area (P3D0.60) Using symmetryY, the middle area of a normal curve has an area of p-0.60, which leaves 1-0.60= 0.40 for the two tails. Each tail will receive half of this number. The left tail will use p-0.20. The right tail will use 1-0.20 = 0.80. In cell B5 type: =NORM.INV(0.20,70,10) In cell C5 type: =NORM.INV(0.80,70,10) Complete.cels 87to 89 and C9 in the same manner


Extracted text: Left area of p30.39 Right area of p%3D0.24 Middle area of p-0.72 8. 12 9,