Question: QUESTION 3 Use regression to look at the relationship between returns on the Hang Seng and US over the same period used in the previous

QUESTION 3 Use regression to look at the relationship between returns on the Hang Seng and US over the same period used in the previous questions. That is, estimate Hang Seng = Bo + BUSt. This is to be done using the three approaches in the regression example on Canvas (sample regression example.xlsx). All three approaches should yield the same answer. That is: n (a) Use the solver to find the values of Bo and B, that minimize I'M (b) Ensure that the values of Bo and B, satisfy the normal equations. (c) Use Excel's regression function to confirm the results in parts (a) and (b). (d Next, evaluate these results by: Interpreting the coefficient of determination and the F-statistic. Conduct a t-test on the slope coefficient. Examine and graph the residuals, then comment. Briefly explain the implications of these findings
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
