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

question 14

Multiple Choice

Excel's __________ function can be used to calculate a p-value for a hypothesis test when σ is unknown.

• A) RAND
• B) T.DIST
• C) NORM.S.DIST
• D) Not enough information is given to answer this question.

---

Definitions:

Standard of Living

The degree of prosperity, amenities, tangible assets, and basic needs accessible to an individual, community, or country.

Consumer Price Index

A tool that measures the typical fluctuation across time in the costs faced by urban shoppers for a specified mix of consumer goods and services.

GDP Deflator

A measure of the price level of all new, domestically produced, final goods and services in an economy, used to adjust nominal GDP to real GDP.

Substitution Bias

A distortion in the Consumer Price Index due to changes in consumer purchase behavior or product substitutions.