How do I complete this problem?
- Complete 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
- Include a copy of your Excel file with the regression output in the a separate sheet