Use the Regression facility under the Data Analysis menu to calculate the beta of each stock and of the portfolio (beta here is called the coefficient of the X-variable). Look at the standard error of the estimate in the cell to the right. How confident can you be of your estimates of the betas of each stock? How about your estimate of the portfolio beta?
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.