When Using Excel to Calculate a P-Value for a Lower-Tail

question 78

Multiple Choice

When using Excel to calculate a p-value for a lower-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.

---

Definitions:

Physical Property

A characteristic of a substance that can be observed or measured without changing the substance's identity.

Impossible Figures

Optical illusions or drawings of objects that appear to be real and three-dimensional but are geometrically impossible to exist in reality.

Three-Dimensional Space

A geometric setting in which three values are required to determine the position of an element (point, object).

Two-Dimensional Pictures

Images with only height and width, lacking the depth dimension, used in various visual contexts.