The data in apple.xlsx tracks monthly performance of stock in Apple Computer since its reception in 1980. The data include 300 monthly returns on Apple Computer, IBM stock returns as well as returns on the entire stock market. Formulate the model with Apple Return as the response and Market Return and IBM Return as explanatory variables. (a) Examine scatterplots of the response versus the two explanatory variables as well as the scatterplot between the responses. Do you notice any unusual features in the data? Do the relevant plots appear straight enough for multiple regression?
(b) Fit the indicated multiple regression and show a summary of the estimated features of the model.
(c) The regression of Apple returns on market returns estimates β for this stock to be about 1.5.
Does the multiple regression suggest a different slope for the market?
(d) Give a confidence interval for the coefficient of IBM returns and carefully interpret this estimate.
(e) Does the inclusion of IBM returns improve the fit of the model with just market returns by a statistically significant amount? Does this imply that we've found an improved trading scheme?
Attachment:- Assignment.rar