Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Statistics and Probability Expert

Estimation of linear regression model 

A CEO of a large pharmaceutical company would like to conclude 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 procedure 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. Carefully read the ex 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

Assume there is a statistically significant relationship. Use the least square method to find the regression equation to predict the advertising costs based on the number of orders received. Please make use of the regression procedure within Excel under Tools > Data Analysis to construct this equation.

Statistics and Probability, Statistics

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

Have any Question? 


Related Questions in Statistics and Probability

What was abraham lincolns view of slavery from the 1840s

What was Abraham Lincoln's view of slavery from the 1840s into the late 1850s, and how did it evolve? How did secession come about, and where did the sentiments for it originate? where did the sentiments for it originate ...

Scenario dr olson is interested in the effects of three

Scenario: Dr. Olson is interested in the effects of three different methods for losing weight in long-distance truck-drivers. He tested a sample of 60 truck drivers. Participants were randomly assigned to one of three gr ...

A researcher conducted an experiment on the effects of a

A researcher conducted an experiment on the effects of a new "drug" depression. The researcher had a control group, and an experimental group that received nothing, a placebo group, and an experimental group that receive ...

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 ...

1 use your own random mu sigma to generate four sets of

1) Use your own random (μ, σ) to generate four sets of (normal-distribution based) random numbers (i.e., samples) of sizes n = 5, 20, 80, and 320, respectively. 2) Calculate the means and standard deviations for the 4 sa ...

Suppose that a certain college class contains 42 students

Suppose that a certain college class contains 42 students. Of these, 23 are freshmen, 28 are history majors, and 8 are neither. A student is selected at random from the class. (a) What is the probability that the student ...

1 what does the error of estimation tell us about the

1. What does the error of estimation tell us about the results of a study conducted using probability sampling? 2. What happens to the error of estimation as one's sample size increases?

What are the key components of consideration that went into

What are the key components of consideration that went into forming the Texas Constitution?

Statistics assignmentquestions address all of the following

Statistics Assignment Questions: Address all of the following questions in a brief but thorough manner. • What are the most common measures of central tendency? Include brief definitions for the common measures of centra ...

Mrjassica manager of appliances for midtown department

Mr.jassica, Manager of appliances for midtown department store feels that her inventory levels of stoves have been running higher than necessary. Before revising the inventory policy for stoves she records the number sol ...

  • 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