Which Excel Function Would Not Be Appropriate to Use When

question 61

Multiple Choice

Which Excel function would not be appropriate to use when conducting a hypothesis test for a population proportion?

• A)NORM.S.DIST
• B)COUNTIF
• C)STDEV
• D)All are appropriate.

---

Definitions:

Yield

The income return on an investment, such as the interest or dividends received, typically expressed as an annual percentage rate based on the investment's cost, its current market value, or its face value.

Face Value

The nominal or dollar value stated on a security or financial instrument, such as a bond or stock.

Real Rate

The interest rate adjusted for inflation, reflecting the true cost of borrowing.

Inflation Rate

The rate that reflects how the overall prices of services and goods escalate, causing a reduction in the capacity to purchase.