When using Excel to calculate a p-value for an upper-tail hypothesis test, which of the following must be used?
A) RAND
B) 1 − NORM.S.DIST
C) NORM.S.DIST
D) Not enough information is given to answer this question.

Question

Quizplus · Accepted Answer

For an upper-tail hypothesis test in Excel, you would use "1 − NORM.S.DIST" to calculate the area in the tail, which corresponds to the p-value. This is because NORM.S.DIST gives the cumulative distribution function up to a point, and subtracting this from 1 gives the upper tail's area.

When Using Excel to Calculate a P-Value for an Upper-Tail