For each stock, calculate the weekly returns using the adj. close price. Describe the distribution of the weekly returns using descriptive statistics including central tendency of returns, dispersion, and shape of the distribution. Use graphs (histogram or over-laid charts) to contrast the distributions of stock returns within each industry. (b) Calculate correlations, and variance/covariance between each pair of risky assets, i.e. you need to create a variance/covariance matrix and a correlation matrix for all stocks. Compare the relative risk among all stocks within each industry and cross industries. Compare the performance of stocks with the S&P 500 index. (c) If you create a portfolio with equal weights among the ten stocks, find the portfolio return, portfolio volatility and the sharpie ratio of the portfolio. Use the treasury yield data to calculate the risk-free rate of return.

(d) If you invest differently on each asset in the portfolio (design your own portfolio to find an optimal portfolio), find the optimal portfolio return, portfolio volatility and the sharpie ratio. Compare this portfolio with the one in question (c). After you finish the analysis and save the tables by excel format. In the first tab of the excel file, list all group members name and percentage of each members contribution to the project and how much percentage of the work is done by each group member. Use a separate table for each stock and name the tables correspondingly. You need to use a word file to summarize your analysis results (about 10 pages). It should include introduction of each company, the performance and risk level of each stock over last three years, the relative risk among all stocks in your portfolio. Name the file by your group name such as group1_project1. Each group only needs to submit one copy.