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

What is the comparison between the threat that the world

What is the comparison between the threat that the world faced from the fascists and communists during the 20th century and the threat faced by the world today from radical Islam? Be sure to include specific two historic ...

Throughout the early 1800s the influence of

Throughout the early 1800's the influence of industrialization and the repeated subjugation of Native Indians and slaves caused people to reflect on their role in society and attempt to reform elements of their daily liv ...

Suppose a researcher believes that college faculty vote at

Suppose a researcher believes that college faculty vote at a lower rate than college students. She collects data from 200 college faculty and 200 college students using simple random sampling. If 120 of the faculty and 1 ...

Mimi joined umuc basketball team since summer 2016 on

Mimi joined UMUC basketball team since summer 2016. On average, she is able to score 30% of the field goals. Assume she tries 15 field goals in a game. (a) Let X be the number of field goals that Mimi scores in the game. ...

Mouse parts produces mouse ears white gloves and other

Mouse Parts produces mouse ears, white gloves and other parts that are incorporated into the production of Mickey Mouse souvenirs. One of the components used in production has an annual demand of 250 units, and this is c ...

Experiments on learning in animals sometimes measure how

Experiments on learning in animals sometimes measure how long it takes a mouse to find its way through a maze. Long experience indicates that the mean time is 20 seconds for one particular maze. A researcher thinks that ...

Validity true story i once spoke to a retired professor who

Validity: True story: I once spoke to a retired professor who used to teach general studies geography. His grading technique was to throw the papers/tests on the ground and randomly assign the same grade to each pile (wi ...

A study found that consumers spend an average of 24 per

A study found that consumers spend an average of $24 per week in cash without being aware of where it goes. Assume that the amount of cash spent without being aware of where it goes is normally distributed and that the s ...

According to pew research center 71 of internet users

According to Pew Research Center, 71% of Internet users accessed video-sharing sites in August2011. A random sample of 50 Internet users was selected. Using the normal approximation to thebinomial distribution, what is t ...

The percentage of people who recycle their old phone books

The percentage of people who recycle their old phone books is 15.8% on average. If 240 people are randomly selected, what is the probability that more than 20% of them recycle their phone books?

  • 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