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

Tell whether each of the following relationships reflects a

Tell whether each of the following relationships reflects a positive or a negative correlation: a. the amount of stress in people's lives and the number of colds they get in the winter b. the amount of time that people s ...

Anbsppsychologist would like to examine the effects of a

A psychologist would like to examine the effects of a new drug on the activity level of animals. Three samples of rats are selected with n = 5 in each sample. The rats in the first sample serve as a control and do not ge ...

Connie wants to have an annuity payment of 2000 at the end

Connie wants to have an annuity payment of $2,000 at the END of every three months. How much should she deposit now at 6% interest, compounded quarterly, to yield this payment for 3 years? (Use Table 12-2 in your text) $ ...

1 what is validity2 distinguish between face validity

1. What is validity? 2. Distinguish between face validity, construct validity, and criterion-related validity. In general, which kind of validity is least important to researchers? 3. Can a measurement procedure be valid ...

Consider the following belief space where the set of

Consider the following belief space, where the set of players is N = {I, II}, and the set of states of nature is S = {s 1 , s 2 }: Write out the belief hierarchies of orders 1, 2, and 3 of Player I, at each state of the ...

Plot four different regression graphs x v y tomatometer v

Plot four different regression graphs (X v Y): Tomatometer v Audience, Budget v Gross, Budget v Tomatometer, Audience v Gross and find the best-fit line equation and correlation coefficient (r-value) for each one. X repr ...

Assignmentsuppose that there are two candidates ie jones

Assignment Suppose that there are two candidates (i.e., Jones and Johns) in the upcoming presidential election. Sara notes that she has discussed the presidential election candidates with 15 friends, and 10 said that the ...

A spinoff of the anti-war and civil rights movements of the

A spinoff of the anti-war and civil rights movements of the 1960s that affected women was? increased desire to return to the security of homes and families decreased political involvement. the birth of the women's libera ...

A family is relocating from st louis missouri to california

A family is relocating from St. Louis, Missouri, to California. Due to an increasing inventory of houses in St. Louis, it is taking longer than before to sell a house. The wife is concerned and wants to know when it is o ...

Peggy wants to know if her pack of cookies was

Peggy wants to know if her pack of cookies was statistically different from those of the rest of the class. She found out the average number of chips per cookie this year was 13.82 and the standard deviation for the clas ...

  • 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