Please show work !!!

Problem 3. (16 points) The following data were collected for 12 months using a company's sales reports. The report shows, for each month, the amount of money the company spent for advertising (x) and the amount of sales (y) made after those advertising expenditures. Both the advertising and sales dollars are in units of thousand dollars. The Chief Executive Officer of the company is interested in the impact of the advertising spending on the actual sales. Month X y 1 52 5,137 2 58 5,841 3 69 6,952 4 75 7,755 5 83 7,931 6 82 7,810 7 78 7,249 8 65 6,072 9 54 5,104 10 48 4,675 11 41 3,124 12 42 3,465 (a) Provide the scatter plot for advertising vs sales dollars with the trend line. (3 points) (b) Obtain a linear regression line for the data. (Hint: You need to calculate a and b to get the linear regression equation: y= a + bx) (9 points) (c) Predict the sales figures in months 13 and 14 if the advertising budgets allocated for months 13 and 14 are $35,000 and $40,000, respectively. (4 points) Problem 4. (8 points) To support National Heart Week, the Heart Association plans to install a free blood pressure testing booth in El Con Mall for the week. Previous experience indicates that, on average, 24 persons per hour request a test. Assume arrivals are Poisson distributed from an infinite population. Blood pressure measurements can be made, on average, in 2 minutes. Assume the queue length can be infinite with FCFS discipline. a) What is the average number of people in line? (2 points) b) What is the average number of people in the system? (2 points) c) What is the average amount of time that a person can expect to spend in line? (2 points) d) On average, how much time will a person spend in the system? (2 points)