Rate of return, standard deviation, coefficient of variation Personal Finance Problem Mike is searching for a stock to include in his current stock portfolio. He is interested in Hi-Tech Inc.; he has been impressed with the company's computer products and believes Hi-Tech is an innovative market player. However, Mike realizes that any time you consider a technology stock, risk is a major concern. The rule he follows is to include only securities with a coefficient of variation of returns below 1.16. Mike has obtained the following price information for the period 2015 through 2018: Hi-Tech stock, being growth-oriented, did not pay any dividends during these 4 years. a. The rate of return for year 2015 is %. (Round to two decimal places.) Data Table The rate of return for year 2016 is %. (Round to two decimal places.) The rate of return for year 2017 is %. (Round to two decimal places.) in order to copy the contents of the data table below (Click on the icon here into a spreadsheet.) The rate of return for year 2018 is %. (Round to two decimal places.) b. The average return over this time period is %. (Round to two decimal places.) Year c. The standard deviation of returns over the past 4 years is %. (Round to two decimal places.) 2015 2016 2017 2018 Stock price Beginning $14.99 $20.83 $63.61 $72.98 End $20.83 $63.61 $72.98 $90.39 d. The coefficient of variation of returns for Hi-Tech stock is (Round to two decimal places.) e. Given the calculation in d what should be Mike's decision regarding the inclusion of Hi-Tech stock in his portfolio? (Sele Mike will include Hi-Tech stock in his portfolio because the coefficient of variation of the security is below 1.16. Mike will not include Hi-Tech stock in his portfolio because the coefficient of variation of the security is not below 1.16. Print Done