Question: X Problem 2. (20 points) The following data were collected during a 14 month from a company's sales reports. The report shows for each month,

X Problem 2. (20 points) The following data were
X Problem 2. (20 points) The following data were collected during a 14 month from a company's sales reports. The report shows for each month, how much the company has spent for advertising (x) and how much sales were made during that month (y). Both the advertising and sales dollars are in units of Smillion. The Chief Executive Officer of the company is interested in the impact of the advertising spending on the actual sales. Month Month 24 79 8 23 83 2 32 85 9 19 75 3 45 89 10 20 77 4 42 86 11 17 90 5 56 101 12 29 93 6 52 100 13 38 95 7 35 88 14 26 90 (a) 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) (12 points) (b) Predict the sales figures in months 15 and 16 if the advertising budgets allocated for months 15 and 16 are $25 million and $30 million, respectively. (8 points)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!