ico Question Help P8-9 (Similar to Rate of retum, standard deviation, coolficient of variation Personal Finance Problem Mikeis searching for a stock to include in his current stock portfolio Hels Interested in Hi-Tech Inc, he has been impressed with the company's computer products and believes Hi-Toch is an innovative market player. However, Mike realizes that any time you consider a technology stock is ha a major concern. The rule he follows is to include only securities with a collident of variation of returns below 1.19 Mike has obtained the following price information for the period 2015 through 2018 Hi Tech stock being growth oriented, did not pay any dividenda during these 4 years Calculate the role of return for each year 2015 through 2018. for Hi-Tech stock Aibua that each year's return is equally probable and calculate the average return over this time period e. Calculate the standard deviation of res over the past years Hot Treat this data as a sample) d. Based on and determine the coefficient of won of returns for the security e. Given the calculation in what should be decision regarding the inclusion of Techstock in his portfolio? 4. The rate of retum for year 2015 Round to two decimal places) i not pay any a Data Table (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) Year 2015 2016 2017 2018 Stock price Beginning $14.82 $20.46 $64.64 $72.32 End $20.46 $64.64 $72.32 $91.61 Print Done