Excel's __________ function can be used to calculate a p-value for a hypothesis test.
A) RAND
B) NORM.S.DIST
C) NORM.S.INV
D) Not enough information is given to answer this question.

Question

Quizplus · Accepted Answer

The NORM.S.DIST function in Excel can be used to calculate the area under a normal distribution curve to the left of a given z-score (which can be calculated using the sample mean, population mean, sample standard deviation, and sample size for a hypothesis test). The p-value is then obtained by subtracting this area from 1 (or, for a two-tailed test, doubling it and subtracting from 2).

Excel's __________ Function Can Be Used to Calculate a P-Value