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?

Question

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?

Quizplus · Accepted Answer

The Answer of 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?

The Following Is Return Data for a Retail Sector ETF