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

A researcher found a significant relationship between a

A researcher found a significant relationship between a student's IQ, x1, grade point average, x2, and the score, y, on the verbal section of the SAT test. The relationship can be represented by the multiple regression e ...

1 gender was life better for women during the middle ages

1. GENDER Was life better for women during the Middle Ages than in past ages? What major events had an impact on their daily life? What role did magic play in the Middle Ages and how did it affect women? How were older w ...

An alternative to the experiment in q3 to investigate

An alternative to the experiment in Q.3 to investigate whether loud music tends to increase the time it takes mice to complete a maze would involve randomly assigning say, 50 mice to two groups. The 25 mice in Group A (c ...

A teacher wants to estimate the average pa of all teachers

A teacher wants to estimate the average pa of all teachers in a district. She wants to be 95% sure her estimate is correct. The standard deviation is $1,000, how large must her sample be to be accurate within $200? Pleas ...

Under what conditions is a grouped frequency distribution

Under what conditions is a grouped frequency distribution more useful as a means of describing a set of scores than a simple frequency distribution? Why do researchers often add relative frequencies to their tables?

A professor has learned that four students in her class of

A professor has learned that four students in her class of 18 will cheat on the exam. She decides to focus her attention on seven randomly chosen students during the exam. a. What is the probability that she finds at lea ...

In minitab open the data set pulsemtw you may assume that

In Minitab, open the data set PULSE.mtw. You may assume that these 92 students are a random sample of all undergraduates. (a) Obtain a 95% confidence interval for µ F  - µ M , the extent to which average pulse rates of f ...

1 why does quasi-experimentation sometimes require the use

1. Why does quasi-experimentation sometimes require the use of "patched-up" designs? 2. Discuss the philosophy of critical multiplism as it applies to quasi-experimental research.

What was the highest point of the popes power and what was

What was the highest point of the pope's power and what was the lowest point?

A person goes to his office everyday he has a single

A person goes to his office everyday. He has a single umbrella. When he is home and the umbrella is home, he can choose to bring it. He will certainly do so if it is raining, but must decide what to do if is not raining, ...

  • 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