6. Refer to the Excel Viral data posted on eLearning: (14) *If appropriate, you must share your...
Question:
6. Refer to the Excel "Viral" data posted on eLearning: (14) *If appropriate, you must share your relevant regression output to demonstrate where your answers are coming from a. Estimate a typical, ordinary least squares regression model which explains how many (in thousands) clicks a social media video will receive as a function of two predictors: both the channel (X or Y) that hosts the video and the number of paid social media promoters devoted to sharing the video. Write out this estimated equation to explain how many clicks are received (use the estimate values and the specific predictors (not 'x1' e.g.)!). b. Provide the residual plots against each of the two explanatory variables you used in "a" above (channel and promoter). Comment on any irregularities that you notice. If you notice any irregularities in part "b", above, attempt other models which utilize quadratic and/or interaction terms with channel and promoter as explanatory variables. c. If you find a model with residuals which better satisfy our necessary regression assumptions, then write out this new, estimated model. Comment on the statistical significance levels of the predictors and provide and comment on the new residual plots for your finalized model. If you have a 'better' final model than that estimated in part 'a' then make sure to describe why it is better.
Video Clicks (in thousands) | Host | Promoters |
49 | X | 3 |
64 | X | 4 |
144 | X | 5 |
484 | X | 7 |
2916 | X | 12 |
4624 | X | 14 |
6084 | X | 15 |
7569 | X | 16 |
10000 | X | 18 |
14400 | X | 20 |
17689 | X | 21 |
19600 | X | 22 |
9 | Y | 1 |
49 | Y | 4 |
225 | Y | 6 |
1089 | Y | 8 |
1600 | Y | 11 |
4225 | Y | 12 |
4489 | Y | 13 |
7225 | Y | 16 |
9801 | Y | 17 |
16900 | Y | 21 |
19321 | Y | 22 |
25600 | Y | 23 |