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:

Marginal Utility

The additional satisfaction or utility that a person receives from consuming one additional unit of a good or service.

Milk Shakes

A cold beverage made from milk, ice cream, and flavorings or sweeteners such as butterscotch, caramel sauce, or chocolate syrup.

Marginal Utility

The change in satisfaction or utility an individual gains from consuming an additional unit of a good or service.

Consumer Surplus

The gap between what consumers are ready to pay for a product or service and the actual amount they spend.