D3.1

47

Use pivot table to generate count, mean, sample variance on the3-year return, grouped by "market cap" and "star rating". Datasethere.Also, you need to reorder "star rating" to the proper order instead of its alphabetical order.

Mean is the average return and variance is the associated risk. What can you say about the risk and return in relation to market cap size?What can you say about the risk and return in relation to star rating?

Use pivot table to generate count, mean, sample variance on the 10-year return, grouped by "market cap" and "star rating". Do your understandings about market cap and star rating based on 3-year return differ from that based on 10-year return?