Estimate a regression with stock’s excess return as the dependent (Y) variableand the S&P 500 excess return as the independent (X) variable. Tocompute excess return, assume risk free rate to be 2.0%. (15

Suppose the number of equipment sales and service contracts that a store sold during the last six (6) months for treadmills and exercise bikes was as follows: treadmill exercise bike total sold 185 123 service contracts 67 55 the store can only sell a service contract on a new piece of equipment. of the 185 treadmills sold, 67 included a service contract and 118 did not.

Mystic bottling company bottles popular beverages in the bottling department. the beverages are produced by blending concentrate with water and sugar. the concentrate is purchased from a concentrate producer. the concentrate producer sets higher prices for the more popular concentrate flavors. a simplified bottling department cost of production report separating the cost of bottling the four flavors follows:

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.07. 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. calculate the rate of return for each year, 2015 through 2018, for hi-tech stock. b. assume that each year's return is equally probable and calculate the average return over this time period. c. calculate the standard deviation of returns over the past 4 years. (hint: treat this data as a sample.) d. based on b and c determine the coefficient of variation of returns for the security. e. given the calculation in d what should be mike's decision regarding the inclusion of hi-tech stock in his portfolio?