D3.1

Use pivot table to generate count, mean, sample variance on the3-year return, grouped by "market cap" and "star rating". Datasethere

download

.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". understandings about market cap and star rating based on 3-year return differ from that based on 10-year return?

https://docs.google.com/spreadsheets/d/1IEZKmCXBWDx1WMtKQgytK7XO4NFZB2gT/edit#gid=1735721223

(Here is the excel file on google drive and provide the link so you can have access to it via Google Sheets)

https://drive.google.com/file/d/1IEZKmCXBWDx1WMtKQgytK7XO4NFZB2gT/view?usp=sharing