The template for this exercise gives price information and market cap for 10 companies. Compute the stock returns and the individual regressions of returns on the S&P 500.

Use this data to construct a value-weighted portfolio. Show that the R2 of the regression of this portfolio’s returns on the S&P 500 is greater than the value-weighted average R2 of the individual stocks.