Question

how to solve this on excel with formulas given please

The data in the accompanying table represent the total rates of return​ (in percentages) for three stock exchanges over the​ four-year period from 2009 to 2012. Calculate the geometric mean rate of return for each of the three stock exchanges.

Year	A		B	C
2012	6.58		13.56	15.54
2011	5.29		0.000	−1.85
2010	12.00		12.57	16.47
2009	18.79		23.37	43.59

Metal	Geometric mean rate of return
Platinum	15.36%
Gold	15.61​%
Silver	24.92​%

a. Compute the geometric mean rate of return per year for the stock indices from 2009 through 2012.

-stock A

-Stock B

Stock C

Answer 1

stock A=10.54%

Stock B=12.06%

Stock C=17.35%