Conduct a multiple linear regression analysis on the data given in the worksheet

Question

Conduct a multiple linear regression analysis on the data given in the worksheet 'Questionl' and identify the relationship between stock price of apple and the social media. All coefficients in your model must be significant at 95% confidence level. The dependent variable is the Apple stock closing price denoted as CLOSE. The independent variables are the data from social media analytics. The independent variables are Word Count (WC), Tone, Positive Emotions (POSEMO), Social (gossips., friends), Cognitive process (cause), feeling (feel), reward, risk, affect (affective or emotional process) Find the best multiple regression model for predicting the stock price. How good is your model? (15 1 Close WCTone osemo affect reward risk feel cause social 2 115.21 2107980.33 3 113.4 22157 49.09 4 114.32 3275037.44 1152575757.6:3 6 114.71 2256654.90 7 112.44 2665551.16 8 109.064840937.65 9 110.3 4679640.53 10 109.585201540.77 11 110.384596339.17 12 110.78 7578639.02 13 111.31 12054748.12 14 110.7819392235.64 15 109.57872037.06 16 112.12 182794251.38 1.22 0.05 0.08 0.57 0.52 0.72 0.43 0.52 0.24 0.30 0.28 0.30 0.55 0.32 0.81 0.47 0.26 0.45 0.65 0.38 0.90 0.74 0.45 0.40 0.23 0.29 0.23 0.32 0.42 0.41 0.47 0.63 1.99 3.94 4.37 4.08 3.57 3.83 3.67 2.47 1.20 1.66 2.53 0.07 0.30 0.08 1.87 2.40 0.96 1.20 1.57 0.17 1.63 3.79 0.94 1.69 0.23 0.28 0.30 0.69 3.94 1.78 1.25 2.27 0.94 1.33 3.67 4.72

Explanation / Answer

since R square is 0.51 it is not a good model.

For the regressed model if we conduct an ANOVA

the significance of F is more than 0.05 hence the regressed model is not signficant in predicting from the default means model.

close price = 116.65 +1.72E-06 * wc +0.25*tone -34.59*posemo +26.97*affect -2.85*reward -9.49*risk -40.35*feel +21.41*risk -1.24*social

All the p-values of the x-variables are more than 0.05 hence these variables are not significant in prediction of close price.

Coefficients Standard Error t Stat P-value Intercept 116.6486 225.887 0.516402 0.627592 wc 1.72E-06 1.98E-05 0.086927 0.934103 tone 0.250368 8.997514 0.027826 0.978877 posemo -34.5921 334.8575 -0.1033 0.921737 affect 26.97406 178.2154 0.151356 0.885612 reward -2.85107 7.994332 -0.35664 0.73592 risk -9.4866 53.72069 -0.17659 0.86676 feel -40.3585 29.21136 -1.3816 0.22564 cause 21.41472 35.79326 0.598289 0.575715 social -1.24478 10.09059 -0.12336 0.906627

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.