Which of the following functions computes a value such that 2.5% of the area under the standard normal distribution lies in the upper tail defined by this value?
A)=NORM.S.INV(0.975)
B)=NORM.S.INV(0.025)
C)=NORM.S.INV(0.05)
D)=NORM.S.INV(0.95)

Question

Quizplus · Accepted Answer

=NORM.S.INV(0.975) computes the z-score for which 97.5% of the distribution's area is to the left, leaving 2.5% in the upper tail, which matches the question's requirement.

Which of the Following Functions Computes a Value Such That