Marketing Regression

Complete a multiple regression using the data. Use Sales” as the Y Range and “SocialMedia,” “Web” and “Print” as the X-Range. o Include residuals, line-fit plots and Normal probability plots. • Read these https://www.qimacros.com/hypothesis-testing/regression/ • Watch : Multiple Regression Interpretation in Excel. This video provides an example of interpreting multiple regression output in excel: Link for the video: https://www.youtube.com/watch?time_continue=2&v=tlbdkgYz7FM • • 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        

Sample Solution