1. Use Get & Transform on the data to create a query that shows average Beta by ETF Struct. To do this, use the Group By button to group the data by ETF Struct and then create a new column called Avg Beta. Also create a second aggregation that shows the count of each type of fund. Name the query Avg_Beta_by_Structure and load it to a new worksheet.
2. What is the average beta for each type of fund, and how many of each are in the dataset?
3. Create another query, called Average Returns by Category, that shows the number of funds in each category and the average of the 1 year, 3 year, and 5 year returns by category.
4. Return to the data and create a pivot table that shows the same results as you got in part (a).
5. Return to the data and create a pivot table that shows the same results as you got in part (c)