Please help explain how to get the correct answers to this question. Cannot figure it out.

Data table 1 2 3 '13 4 '1? (Click on the {can 1:11 in order to capys contents info a spreadsheet.) $21 35 29 24 (Solving a comprehensive problem) Use the end-of-year stock price data in the popup window, [ ] , to answer the following questions for the Harris and Pinwheel companies. a. Compute the annual rates of return for each time period and for both firms. b. Calculate both the arithmetic and the geometric mean rates of return for the entire three-year period using your annual rates of return from part a. (Note: you may assume that neither firm pays any dividends.) c. Compute a three-year rate of return spanning the entire period (i.e., using the ending price for period 1 and ending price for period 4). d. Since the rate of retum calculated in part c is a three-year rate of return, convert it to an annual rate of return by using the following equation: 1 + Three-Year Annual Rate Rate of Return of Return e. How is the annual rate of return calculated in part d related to the geometric rate of return? When you are evaluating the performance of an investment that has been held for several years, what type of average rate of return (arithmetic or geometric) should you use? Why? a. Enter the annual rate of return for each year for Harris in the table below. (Round to two decimal places.) Time Value of Annual Rate Value of Annual Rate Harris Stock of Return Pinwheel Stock of Return 1 511 521 6 35 W N 13 % 29 17 24