The sample data contains candy sales information during the last 12 weeks for an imaginary...
80.2K
Verified Solution
Link Copied!
Question
Accounting
The sample data contains candy sales information during the last 12 weeks for an imaginary brand. For each week we know the sales, advertising expenditure, and the price of candy*. Based on this information please answer the following questions: 1. Calculate the correlation between sales, advertising expenditures, and price. Then explain the results. (2 points) 2. Run a regression analysis to see if we can predict sales by knowing advertising expenditures and price. Please explain the results based on the regression table. (4 points) 3. Suppose that for the next week we want to spend $30000 on advertising. Also, the price will be $4. Use the regression model you found in the previous question and predict the sales