Solution for QID #97800: This assessment addresses the following course objective(s): | StudyHelpMe

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