1. The following chart is data over an 8 month period that shows how much a company spent in advertising and the sales revenue for that month MONTH ADVERTISINGS SALESS SOMarch 900 56000 April 2400 89000 May 3100 98000 June 1200 55000 July 3500 96000 Aug 1800 56000 Sept 2000 91000 Oct 1950 78000 I AjWhat is the correlation coefficient? (round to 2 decimals) d) What is the linear equation (y = mx + b form) that best approximates the relationship between advertising dollars spent(x) and sales revenue(y) based on the above 8 months of data? (round to 2 decimals for the slope and the y intercept) I e) What sales revenue would the company expect for the following advertising spending? Round to nearest cent a) 3000 b) 2100 c) 1300 f) if you were in charge of the advertising department how much would you spend on each of the next 4 months on advertising and how and why did you arrive at your decision? ) If you were in charge of the advertising department how much would you spend on each of the next 4 months on advertising and how and why did you arrive at your decision? Nov 1 Jan Feb March Please give a short explanation as to how and why you came up with your advertising spending for the above 4 months