Please use excel to solve and show steps. The problem and the data provided must be clearly laid out in the spreadsheet and cell referencing must be used.

4. Given the following information concerning four stocks, Stock A Stock B Stock C Stock D Price $10 17 13 Number of Shares 100,000 50,000 150,000 200,000 20 a) Construct a simple price-weighted average, a value-weighted average, and a geo- metric average. b) What is the percentage increase in each average if the stocks' prices become: i. A: $10, B: $17, C: $13, D: $40 ii. A: $10, B: $34, C: $13, D: $20? c) Why were the percentage changes different in (i) and (ii)