Correlation coefficient and scatter plot

Reference no: EM1322397

Correlation coefficient and scatter plot:

A CEO of a large pharmaceutical company would like to determine if he should be placing more money allotted in the budget next year for television advertising of a new drug marketed for controlling asthma. He wonders whether there is a strong relationship between the amount of money spent on television advertising for this new drug called XBC and the number of orders received. The manufacturing process of this drug is very difficult and requires stability so the CEO would prefer to generate a stable number of orders. The cost of advertising is always an important consideration in the phase I roll-out of a new drug. Data that have been collected over the past 20 months indicate the amount of money spent of television advertising and the number of orders received.

The use of linear regression is a critical tool for a manager's decision-making ability. Please carefully read the example below and try to answer the questions in terms of the problem context. The results are as follows:

Month	Advertising Cost (thousands of dollars)	Number of Orders
1	$68.93	4,902,000
2	72.62	3,893,000
3	79.58	5,299,000
4	58.67	4,130,000
5	69.18	4,367,000
6	70.14	5,111,000
7	83.37	3,923,000
8	68.88	4,935,000
9	82.99	5,276,000
10	75.23	4,654,000
11	81.38	4,598,000
12	52.90	2,967,000
13	61.27	3,999,000
14	79.19	4,345,000
15	80.03	4,934,000
16	78.21	4,653,000
17	83.77	5,625,000
18	62.53	3,978,000
19	88.76	4,999,000
20	72.64	5,834,000

Set up a scatter diagram and calculate the associated correlation coefficient. Discuss how strong you think the relationship is between the amounts of money spent on television advertising and the number of orders received. Please use the Correlation procedures within Excel under Tools > Data Analysis. The Scatter plot can more easily be generated using the Chart procedure.

Reference no: EM1322397

Questions Cloud

Interpretation of slope-intercept and regression equation : The use of linear regression is a critical tool for a manager's decision-making ability. Please carefully read the example below and try to answer the questions in terms of the problem context.

Find the new force : Two charges, q1 and q2, are separated by a distance, r, and exert a force, F, on each other. What will the new force be if:

The advantages and disadvantages of various reference frames : An elevator accelerates upward at 1 m/s2. When the elevator is moving upward at 2 m/s, a bolt drops from the ceiling which is 2.5 m above the?

The electric flux through the circle : What is the electric flux through the circle when its face is perpendicular to the field lines?

Correlation coefficient and scatter plot : The Scatter plot can more easily be generated using the Chart procedure.

A uniform electric field and accelerates to the north : An electron is released from rest in a uniform electric field and accelerates to the north at a rate of 199m/s2. What is the magnitude of the electric field?

Estimation of linear regression model : Please use the regression procedure within Excel under Tools > Data Analysis to construct this equation.

Calculate the magnitude of the electric field : Calculate the magnitude of the electric field at one corner of a square 1.43

Sum of squared error : Choose the correct answer using sum of squared error (SSE).

User Account

All Pages