Identify the Statistical Function Used If the Rank Value Returned

question 22

Multiple Choice

Identify the statistical function used if the rank value returned for duplicate values was 8.5?

• A)RANK.AVG
• B)RANK.EQ
• C)RANK.SP
• D)RANK

---

Definitions:

Stock Market

A public market for buying, selling, and trading stocks (shares) of publicly-held companies.

Alpha

A measure of the excess return of an investment relative to the return of a benchmark index.

Actual Return

The real gain or loss experienced on an investment, typically expressed as a percentage of the investment's initial cost.

Portfolio Beta

This measures the sensitivity of a portfolio's returns to changes in the market's returns, indicating the portfolio's overall exposure to market risk.