Question: Please show work 69 The following data were collected for 12 months using a company's sales reports. The report shows, for each month, the amount

Please show work Please show work 69 The following data were

69 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 1 52 4,670 2 58 5,310 6,320 4 75 7,080 83 7,210 82 7,040 7 78 6,590 65 5,520 9 54 4,640 48 4,000 11 41 2,840 12 42 3,170 HO00 Vou w (a) Provide the scatter plot for advertising vs sales dollars with the trend line. (4 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) (8 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. (6 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!

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...

Problem 3. (18 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 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...

help with all please For all the problems, to receive full score, you must show your complete and accurate work, i.e., show how you calculated the numbers you use. If you only provide the final...

please help with all questions For all the problems, to receive full score, you must show your complete and accurate work, i.e., show how you calculated the numbers you use. If you only provide the...

BUS ADM 370 - Introduction to Supply Chain Management Homework 1 (50 points) For all the problems, to receive full scores, you have to show your complete and accurate work, i.e., show how you...

PLEASE DO MANUALLY NOT USING CODE 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...

please do both problems Problem 3. (18 points) The following data were collected f 12 months using a company's sales reports. The report shows, for each month, the amount of money the company spent...

Search@UW - zoom fatigue X E Understanding "Zoom fatig x Homework 1 BUSADM370_HW1_FA21.pc X Bus Adm 370 Fall 2007 Introduction to Supply Cha X + E c...

A major department store chain is having an end-of-season sale on refrigerators. The number of refrigerators sold during this sale at a sample of 10 stores was: 80 110 0 40 70 80 100 50 80 30 a. Is...

Glen, whose tax rate is 33%, sells each of the following assets for $200,000. Each case is an independent case. Sec 1231 Gain Ordinary Taxed at Taxed at Taxed at Taxed at (Loss) Income | 33% 25% 20%...

1 . Investment interest expense may be deducted only to the extent of net investment income; excess interest that cannot be deducted because of this limitation may be carried back three years and...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...