Provide the scatter plot for the data with the trend line

Assignment Help Operation Management

Reference no: EM131920650

Problem

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 $million. The Chief Executive Officer of the company is interested in the impact of the advertising spending on the actual sales.

Month	x	y	Month	x	y
1	29	84	8	28	88
2	37	90	9	24	80
3	50	94	10	25	82
4	47	91	11	22	95
5	61	106	12	34	98
6	57	105	13	43	100
7	40	93	14	31	95

Provide the scatter plot for the data with the trend line.

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)

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.

Reference no: EM131920650

Questions Cloud

Compute the order price at which msi would be indifferent : Should MSI accept the special order? Compute the special order price at which MSI would be indifferent between accepting or rejecting the special order.

What sequence should be used : The Budd Gear Co. specializes in heat-treating gears for automobile companies. At 8:00 a.m., when Budd's shop opened today.

Compute cost of goods purchased and cost of goods sold : Assuming that Mountain Lake Corporation uses the periodic system, compute cost of goods purchased and cost of goods sold.

What is the maximum number of connection requests : A connection request packet is L = 125 bytes long and the channel has a bit rate of Rb = 100 Kbit/s. What is the maximum number of connection requests per unit.

Provide the scatter plot for the data with the trend line : 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.

Probability that transmission is successful on first attempt : What is the probability that a transmission is successful on its first attempt? What is the probability that it takes exactly k attempts for a transmission.

Explain the purpose of recording depreciation expenses : Mr. Fogle, the President of a company that manufactures food. Do you agree or disagree of Mr. Fogle, explain the purpose of recording depreciation expenses.

Compute the expected labor and multifactor productivity rate : Compute the expected labor and multifactor productivity rates for each unit.

What is mr cs maximum amount of depreciation deduction : Mr.c purchased office furniture costing 10000. the furniture has an ADR midpoint life of 10 year. What is C's maximum amount of depreciation deduction for 2016?

User Account

All Pages