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?

Var of 1YrReturn% Column Labels Row Labels Growth Value Grand Total Low 7.11 9.97 8.74 Average 19.66 17.61 18.93 High 31.61 34.07 31.68 Grand Total 31.50 25.44 29.59count 407 sample mean 7.81 sample variance 29.59 sample STD 5.44 population mean 7.81 population variance 29.52 population STD 5.43Star Rating Five Sum of 1YrReturn% Column Labels Row Labels Average High Low Grand Total Growth 99.23 14.7 11.27 125.2 Large 88.93 14.7 103.63 Mid-Cap 11.27 11.27 Small 10.3 10.3 Value 28.89 28.89 Large 11.14 11.14 Mid-Cap 17.75 17.75 Grand Total 128.12 14.7 11.27 154.09