Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Statistics and Probability Expert

Correlation coefficient and scatter plot. 

A CEO of a large pharmaceutical company would like to conclude if he has to 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 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 point to 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 instance below and try to answer the problems 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 find out the associated correlation coefficient. Examine 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.

Interpret the meaning of the slope, b1, in the regression equation.

Predict the monthly advertising cost when the number of orders is 5,100,000.

Compute the coefficient of determination, r2, and interpret its meaning.

Compute the standard error of estimate, and interpret its meaning.

Statistics and Probability, Statistics

  • Category:- Statistics and Probability
  • Reference No.:- M922931

Have any Question? 


Related Questions in Statistics and Probability

A random variable x has a gaussian pdf with mean 5 and unit

A random variable, X, has a Gaussian PDF with mean 5 and unit variance. We measure 10 independent samples of the random variable. (a) Determine the expected value of the sample mean. (b) Determine the variance of the sam ...

How did egypts physical location along the nile river

How did Egypt's physical location along the Nile River affect the culture's political system,religion, and art? Explore at least three examples.

Letnbspnbspbe a sequence of independent poisson counting

Let   be a sequence of independent Poisson counting processes with arrival rates, Show that the sum of all of these Poisson processes, is itself a Poisson process. What is the arrival rate of the sum process?

A student working on a summer internship in the economic

A student working on a summer internship in the economic research department of a large corporationstudied the relation between sales of a product (Y , in millions of dollars) and a population (x, in millionsof persons) ...

Letnbspnbspbe a wide sense stationary gaussian random

Let   be a wide sense stationary Gaussian random process and form a new process according to  is a constant and is a random variable uniformly distributed over   and independent of  (a) Is Y(t) wide sense stationary? (b) ...

Hotels are rated on the basis of one to five stars the

Hotels are rated on the basis of one to five stars. The Holiday Stay Hotel chain rated all 50 of it's hotels. The data is shown in the diagram below. Number of Stars  Frequency  1            7 2 10 3 22 4 8 5 3 1. Find t ...

1 a stock broker knows that the end-of-year balance x

1. A stock broker knows that the end-of-year balance X (percent of the January 1 balance) in the client,s account has a distribution with mean μ percent and standard deviation σ = 10. The broker collected a sample of 49 ...

A box contains 11 two-inch screws of which 6 have a philips

A box contains 11 two-inch screws, of which 6 have a Philips head and 5 have a regular head. Suppose that you select 3 screws randomly from the box. What is the probability that there will be more than one Phillips head ...

Following the lead of given example design an optimum 2-bit

Following the lead of given example, design an optimum 2-bit quantizer for a signal whose samples follow a triangular PDF, (a) Find the four quantization levels   and the three boundary points,  (b) Find the mean-squared ...

Suppose x is a rayleigh random variable and is an arcsine

Suppose X is a Rayleigh random variable and is an arcsine random variable, so that Furthermore, assume and are independent. Find the PDF of Z =XY.

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate