(Descriptive statistics of two stocks) Here is the stock price history of “HighTech” and “LowTech” corporations.

Calculate:

a. The annual returns for each stock.

b. The mean (average) 10-year return for the period for each firm.
Which stock has the higher average return?

c. The variance and the standard deviation of returns, for the period of 10 years for each firm. Which stock is riskier?

d. The covariance and correlation of the returns for each firm. Use two formulas to compute the correlation: The Excel function Correl and the definition

e. If you had to choose between the two stocks, which would you choose? Explain briefly.

Transcribed Image Text:

A 123456789 B HighTech Corp. LowTech Corp. Stock price C Stock price 31-Dec-06 75.00 40.00 31-Dec-07 86.25 45.20 31-Dec-08 125.32 55.60 31-Dec-09 91.64 48.37 31-Dec-10 100.80 32.88 31-Dec-11 145.93 61.64 31-Dec-12 151.21 75.82 31-Dec-13 196.57 97.05 10 31-Dec-14 226.05 109.66 11 31-Dec-15 89.00 122.99