Answer
Consumer Goods Stocks: Mean = 9.805, Median = 10.11
Energy Stocks: Mean = 11.679, Median = 10.76
The energy sector has the higher median rate of return.
Work Step by Step
Calculate the mean and median using the MS Excel AVERAGE and MEDIAN functions.