Use Index Model Data-1.xlsx Download Index Model Data-1.xlsx to answer the following questions:

1. Estimate the monthly return for NIO, CCL, and the market.

2. Create new column and then calculate the average return for both NIO and CCL for each month. This is the same as investing 50% of the money in NIO and the other 50% in CCL. Name this column Portfolio.

3. Estimate an index model by regression Portfolio return on Market return. Comment on the estimated intercept and beta.