Show transcribed image text 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
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
