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

List an example of each of the followinga two quantitative

List an example of each of the following: a. Two quantitative variables that are likely to have a positive linear relationship. b. Two quantitative variables that are likely to have a negative linear relationship. c. Two ...

In a health insurance experiment performed in a super

In a health Insurance experiment performed in a Super Specialty Hospital 4 types of insurance categories patients are expected to occur in the proportion of 9: 3: 3: 1. The observed frequencies are 891 Insured and Surgic ...

A researcher studying correctional treatment on 192 sex

A researcher studying correctional treatment on 192 sex offenders composed of 10 females and 182 males finds that 11 males along with 1 female had reoffended. He then calculates the percentages and finds that 10% of fema ...

Module assignmentthe paired data below consists of test

Module Assignment The paired data below consists of test scores and hours of preparation for 5 randomly selected students. Use this data set to answer the questions below: x Hours of preparation   5    2    9   6   10 y ...

Case study mikhail gorbachevs 1988 un speechif the pace of

Case Study: Mikhail Gorbachev's 1988 UN SpeechIf the pace of improving US-Soviet relations seemed rapid, Mikhail Gorbachev's speech to the United Nations General Assembly would shift the process into overdrive.  In this ...

The question to address is what have you learned about

The question to address is: "What have you learned about statistics?" In developing your responses, consider - at a minimum - and discuss the application of each of the course elements in analyzing and making decisions a ...

This course is designed to provide you with the knowledge

This course is designed to provide you with the knowledge and skills in application, evaluation, analysis, and interpretation of biostatistical data used to inform public health programs, policy, and practice. View the o ...

1 consider a test of h0 mu le 100 versus h1 mu gt 100

1. Consider a test of H0 : μ ≤ 100 versus H1 : μ > 100. Suppose that a sample of size 20 has a sample mean of X = 105. Determine the p-value of this outcome if the population standard deviation is known to equal  (a) 5; ...

A history class is comprised of 6 female and 7 male

A history class is comprised of 6 female and 7 male students. If the instructor of the class randomly chooses 11 students from the class for an oral exam, what is the probability that 5 female students and 6 male student ...

Measures of central tendency summative taskon a separate

Measures of Central Tendency Summative Task On a separate paper hand out the solution of the two parts of the investigation: Part One - Use the given data set to solve the following problems: 50, 55, 60, 60,70, 80 A. Fin ...

  • 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

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

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen