Company = Migros. (Migros Ticaret A.. is one of the supermarket chains in Turkey.)

1. Find the monthly returns for the stock and market data, separately. Use the following equation:

% Return = x 100

2. Assume that you put 50% of your money in your stock and 50% of your money in BIST 100. Calculate:

1. Expected return for your portfolio
2. Variance of this portfolio
3. Standard deviation of this portfolio

3. Using a scatter plot function, plot the returns of the stock against the returns of the market. Make sure you put the market returns on the x axis and stock returns on the y axis.

4. Right click on the data points in graph, and click on Add Trendline to find the equation of the line. Make sure you also click on Display equation on chart to see the equation of the line.

5. From this equation, find the beta of the stock.