Excel's NORM

question 43

Multiple Choice

Excel's NORM.DIST function can be used to compute _____.

• A) cumulative probabilities for a standard normal z value
• B) the standard normal z value given a cumulative probability
• C) cumulative probabilities for a normally distributed x value
• D) the normally distributed x value given a cumulative probability

---

Definitions:

Geometric Average Return

The average rate of return on an investment that is compounded over multiple periods, considering the compounding effect.

Compounding

The process where the value of an investment increases because the earnings on an investment, both capital gains and interest, earn interest as time passes.

Dollar-Weighted Returns

A technique for determining the yield of an investment by considering both the magnitude and timing of the cash inflows and outflows associated with it.

Geometric Returns

The average rate of return per period on an investment, calculated by compounding the returns over time.