Question: 1 . Calculate your dependent variable column, for MSFT risk premium. Then, use the LINEST ( ) array function to compute the regression model results

1. Calculate your dependent variable column, for MSFT risk premium.
Then, use the LINEST() array function to compute the regression model results and statistics, based on the specification earlier described for the F-F three factor model:
Ri Rf = b0+ b1*(Rm Rf)+ b2*SMB + b3*HML + error
Remember LINEST is an array function, so you want to use Ctl-Shift-Enter. Also make sure to enter 1 for the third and fourth argument to the function, to enable the intercept coefficient, and to enable model diagnostic statistics calculation, respectively.
Just to make sure you know which coefficient is which, enter labels for the coefficients in the following section. Recall that as per the documentation, coefficients are ordered from right to left.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!