In this problem, you will estimate the beta of a portfolio. Download the excel spreadsheet titled “pset6_q8_data” from tophat. Columns B-F gives the monthly returns of 5 sectors over the period 200101-202012. Columns I and L give the corresponding market excess returns and risk free rate over the same period.
Estimate the beta of the “HiTec” industry portfolio using the monthly sample 200101-202012. What is the value of your estimate? Round your answer to 2 decimal places.
