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

1 an investigator wants to determine if a new program aimed

1. An investigator wants to determine if a new program aimed at reducing the overall number of pregnancies in a highly populated area is effective (reducing average births below 6 per household). In order to carry out th ...

A coffee store owner knows that a customer gets a coffee in

A coffee store owner knows that a customer gets a coffee in 35% of the store's transactions. If we take a random sample of 300 customers, what is the probability that less than 32% of them buy a coffee? (A) 0.1292 (B) 0. ...

1 prove that every complete irreflexive and transitive

1. Prove that every complete, irreflexive, and transitive relation is asymmetric: if x ≠ y, then x > y if and only if y x. 2. Prove that the Gale-Shapley algorithm for finding a stable matching satisfies the following pr ...

A hospital emergency room analyzed n17665 hourly

A hospital emergency room analyzed n=17,665 hourly observations on its average occupancy rates using six binary predictor variables representing days of the week and two binary predictors representing the 8 hour work shi ...

In a survey of 617males agesnbsp18-64 396 say they have

In a survey of 617males ages 18-64, 396 say they have gone to the dentist in the past year. Construct 90% and 95% confidence intervals for the population proportion. Interpret the results and compare the widths of the co ...

Using the standard normal distribution tables what is the

Using the standard normal distribution tables, what is the area under the standard normal curve corresponding to Z

A new study provides some evidence that playing action

A new Study provides some evidence that playing action video games strengths a person's ability to translate sensory information into accurate decisions. Researchers had 23 male volunteers with an average age of 20 look ...

The mean incubation time for a type of fertilized egg kept

The mean incubation time for a type of fertilized egg kept at 100.7° F is 22days. Suppose that the incubation times are approximately normally distributed with a standard deviation of 2 days. (a) The probability that a r ...

A commuter airline flies airplanes that seat 14 passengers

A commuter airline flies airplanes that seat 14 passengers. From experience, they have learned that, on average, 85% of the passengers holding reservations for a particular flight actually show up for the flight. If they ...

Explain i the hypotheses with a plausible definition of p

Explain (i) the hypotheses with a plausible definition of p or µ, (ii) whether or not the data indicate practical significance (use common sense and/or general knowledge), and (iii) whether or not the data indicate stati ...

  • 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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro