Read Statistical Analysis in Excel. Run a regression analysis on ad budget Download ad budget. Download . Compare the coefficients and see which ad outlets are most effective in increasing sales. Where should Forever 21 invest their ad budget?
[Optional] Read Installing R Perform a regression analysis on ad budget (extended). Download ad budget (extended).Interpret the regression results and identify the advertising outlet (social media, tv, radio) that is most effective in increasing sales.
- Take a screenshot of the linear regression results.
- Interpret the results based on coefficient, p-value, and R-squared. Do social media, tv, and radio ads pay off, and why? (100 words)
- Where should Forever 21 invest their ad budget? (150 words)