X fx B C D E Michelle is searching for a stock to include in her current stock portfolio. She is interested in Star-Tech, Inc.; she has been impressed with the company's computer project and believes that Star-Tech is an innovative market player. However, Michelle realizes that any time you consider a technology stock, risk is a major concern. The rule he follows to to include only securities with a coefficient of variation of returns below the benchmark set below. Michelle has obtained the following price inforomation for the period 2012-2015. Star-Tek stock, being growth-oriented, did not pay any dividends during these 4 years. a. Calculate the rate of return for each year, 2012 through 2015. (5 points) b. Assuse that each year's return is equally probable, and calculate the average return over this time period. (5 points) Introduction 1 2 3 4 5 6+ Workbook Statistics B C H E a. Calculate the rate of return for each year, 2012 through 2015. (5 points) b. Assuse that each year's return is equally probable, and calculate the average return over this time period. (5 points) c. Calculate the standard deviation of returns over the past 4 years. (Hint: Treats these as a sample.) (5 points) d. Based on b and c, deetermine the coefficient of variation of returns for the security. (5 points) e. Given the calculation in d, what should Michelle's decision regarding the inclusion of Star-Tech stock in her portfolio. (5 points) Introduction 1 2 3 4 5 6 2 B 4 6 8 9 0 1 2 3 14 Benchmark coefficient of variation of returns: Stock Price a Year Beginning End Rate of Return 2012 12.36 21.55 2013 21.55 64.78 2014 64.78 72.38 2015 72.38 95.00 b Average return Standard dev d CV e. Michelle should OR should not invest in this stock... Introduction 1 2 3 56+ |||| 4 0.9