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

question 23

Multiple Choice

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.

---

Definitions:

Central Limit Theorem

A statistical theory that states the distribution of sample means approximates a normal distribution as the sample size becomes large, regardless of the population's distribution.

Sampling Distribution

The sampling distribution is a probability distribution of a statistic obtained through a large number of samples drawn from a specific population.

Modality

Value or values of a variable that have the highest frequency in a set of data.

Directional Hypothesis

A specific type of hypothesis that stipulates the direction of the expected relationship between variables (e.g., 'greater than', 'less than').