hw

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)