Solved

The Following Is Return Data for a Retail Sector ETF

Question 14

Essay

The following is return data for a retail sector ETF and energy sector ETF for the years, Year 1 to Year 5. The following is return data for a retail sector ETF and energy sector ETF for the years, Year 1 to Year 5.   (See the Excel Data File.) A) What is the arithmetic mean return for each ETF? B) What is the geometric mean return for each ETF? C) What is the sample standard deviation for each ETF? Which ETF was riskier over this time period? D) Given a risk free rate of 5%, what is the Sharpe Ratio for each ETF? Which investment had a better return per unit of risk over this time period? (See the Excel Data File.)
A) What is the arithmetic mean return for each ETF?
B) What is the geometric mean return for each ETF?
C) What is the sample standard deviation for each ETF? Which ETF was riskier over this time period?
D) Given a risk free rate of 5%, what is the Sharpe Ratio for each ETF? Which investment had a better return per unit of risk over this time period?

Correct Answer:

verifed

Verified

a) Arithmetic Mean Retail =AVERAGE() = 0...

View Answer

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions