Choose any publicly traded company that has stock price data from January 1, 2002 December 31, 2016 and answer the following questions.

Calculate the total dollar return for the stock, using the adjusted close price, if you bought 100 shares of the stock over the past 15 years (1 point).

What was the total percent return using the information from the preceding question (2 points)?

Using the adjusted close price, what were the dividend yield and capital gains yield from May 1, 2007 through April 30, 2008, if you had bought 100 shares of stock (2 points)?

Using the public information, what was your stocks average percent return for the last 15 years (2 points)?

Using excel, create a histogram for the annual percentage return data (2 points).

Using excel, calculate the variance, standard deviation, and geometric average return (9 points).

Explain what the variance, standard deviation, and geometric averages tell you about the stock (3 points).

Using excel, calculate the simple three-month moving average (2 points).

Using theta (), calculate the primary and secondary support levels using the stock prices on September 15, 2015 and January 15, 2016 (2 points).