When using Excel to calculate a p-value for an upper-tail hypothesis test, 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, you calculate the p-value by subtracting the cumulative distribution function (CDF) value from 1, which is done using 1 - NORM.S.DIST in Excel.

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