This assessment addresses the following course objective(s):
· CO3 – Solve business problems with appropriate quantitative decision-making models
In this assignment you will perform a multiple regression analysis inside of Microsoft Excel.
Complete: A secondary regression using the changed data table you just downloaded.
· Complete a multiple regression using the data. Use Sales” as the Y Range and “SocialMedia,” “Web” and “Print” as the X-Range.
· Include residuals, line-fit plots and Normal probability plots.
Analyze what you are able to determine from the regression:
· Regression statistics
· Equation of the line
· Effects of variation of spend in Social Media and Web