Middle 50 percent. (Negative values should be indicated by a minus sign. Round y

Question

Middle 50 percent. (Negative values should be indicated by a minus sign. Round your answers to 4 decimal places.)

Lowest 5 percent. (Negative values should be indicated by a minus sign. Round your answer to 4 decimal places.)

   

Middle 90 percent. (Negative values should be indicated by a minus sign. Round your answers to 4 decimal places.)

  

Find the associated z-score or scores that represent the following standard normal areas. (Hint: Use the Excel function =NORM.S.INV() to find the z-score.)

Explanation / Answer

a) for middle 50% we can find the z for (1-0.5)/2+0.5=0.75 which is =NORM.S.INV(0.75)=0.6745

b) lowest 5% it is  =NORM.S.INV(0.05)=-1.6745

c) middle 90%, we can find for (1-0.9)/2+0.9=0.95 which is =NORM.S.INV(0.95)=1.6745

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---