D3.1 Use pivot table to generate count, mean, sample variance on the3-year return, grouped by market cap
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/6678c74cdc94d_3726678c74cc5433.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/6678c74d3f485_3736678c74d25da0.jpg)
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?
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/6678c74d9f426_3736678c74d8ce30.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/6678c74df3157_3736678c74dd9b8a.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/6678c74e593cc_3746678c74e3b171.jpg)
Related Book For
Posted Date: