Excel's _____ Function Can Be Used to Compute the Expected

question 31

Multiple Choice

Excel's _____ function can be used to compute the expected value of a discrete random variable.

• A) SUMPRODUCT
• B) AVERAGE
• C) MEDIAN
• D) VAR

---

Definitions:

Hong Kong Dollars

The legal currency of Hong Kong, used in financial transactions within the region.

U.S. Dollars

The official currency of the United States, widely used as a benchmark in global financial transactions.

Uncovered Interest Rate Parity

A theory suggesting that the difference in interest rates between two countries is equal to the expected change in exchange rates between those countries' currencies.

Nominal Risk-Free Return

The return on an investment with zero risk in nominal terms, not adjusting for inflation.