Suppose a data set is normally distributed with a mean u = 70 andthe 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 leaves1-0.60= 0.40 for the two tails. Each tail will receive half of this number. The left tail willuse 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 Left area of p30.39Right area of p%3D0.24Middle area of p-0.728.129,

Assume, X be the normally distributed random variable with mean, μ=70 and standard deviation, σ=10.…

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 (p%3D0.60) Using symmetry, 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 cells B7 to B9 and C9 in the same manner.