Question: a. Using Get \& Transform, clean up the data as described in the chapter, and keep only the Fund Name, Symbol

• Question: a. Using Get \& Transform, clean up the data as described in the chapter, and keep only the Fund Name, Symbol, Asset Class, Total Return 2016, Total Return 2015, and Total Return 2014 fields. b. Create calculated columns in the original data that calculate the 2014 to 2016 total return for each ETF and for each Asset Class. Be sure to properly account

  a. Using Get \& Transform, clean up the data as described in the chapter, and keep only the Fund Name, Symbol, Asset Class, Total Return 2016, Total Return 2015, and Total Return 2014 fields. b. Create calculated columns in the original data that calculate the 2014 to 2016 total return for each ETF and for each Asset Class. Be sure to properly account for compounding of returns. c. Create a pivot table to show the avera
• 

  Here’s the best way to solve it.

  Solution