Homework
a. What's the correlation between each 'IMP'(impression) and 'SP'.
b. How's the trend of sales over the months?
c. According to visualization between each 'IMP' and 'SP'. How's the trend of each 'IMP' and 'SP'?
d. Check the segmentation of 'AVERAGE_PRICE' and 'MEDIA_SPEND_of_competitor' for 'Holiday'. Does 'MEDIA_SPEND_of_competitor' have an impact on 'AVERAGE_PRICE'?
e. Check the segmentation of 'Sales' on each 'PROMOTION'. Does 'PROMOTION' boost 'Sales'?
f. Check the coefficient for 'IMP' and 'SP' linear regression model. Summarize the output of the linear regression model, e.g. p-value, r square. What are the indications from these values?
g. What is the marketing mix modeling method? ROI (Return of Investment) of each marketing channel is calculated using this method. How do you interpret contributions to the sales for each marketing channel based on each ROI?
Format your homework according to the give formatting requirements:
a. The answer must be double spaced, typed, using Times New Roman font (size 12), with one-inch margins on all sides.
b. The response also includes a cover page containing the title of the homework, the course title, the student's name, and the date. The cover page is not included in the required page length.
c. Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.