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 recent report suggested that older people think more

A recent report suggested that older people think more slowly than younger people because they have more information stored in their brains. Because WeStudyEverything wasn't sure regarding the source of the study, they d ...

1 how do quasi-experimental designs differ from true

1. How do quasi-experimental designs differ from true experiments? 2. Under what circumstances would a researcher use a quasi-experimental rather than an experimental design?

Romeo composes a letter to juliet and gives it to tybalt to

Romeo composes a letter to Juliet, and gives it to Tybalt to deliver to Juliet. While on the way, Tybalt peeks at the letter's contents. Tybalt gives Juliet the letter, and Juliet reads it immediately, in Tybalt's presen ...

A researcher obtained a sample of 180 participants between

A researcher obtained a sample of 180 participants between the ages of 18 and 24 and calculated the phi coefficient between whether they smoked cigarettes and whether they used marijuana (yes vs. no). Because the correla ...

Assignmentthe production department of the newspaper wants

Assignment The production department of the newspaper wants to ensure that the mean blackness of the print for all newspapers is at least 0.97 on a standard scale in which the target value is 1.0. A random sample of 50 n ...

An airplane manufacturer currently produces six models of

An airplane manufacturer currently produces six models of airplanes for commercial sale. the airline that lauren works for is rapidly expanding and would like to purchase three airplanes of different models to service va ...

Assignment1what is statistics2describe the differences

Assignment 1. What is statistics? 2. Describe the differences between inferential statistics and descriptive statistics. 3. The call center received 30 phone calls on a Monday, below is the number of minutes each call la ...

If 2 of the calls received by schools switchboard are wrong

If 2% of the calls received by schools switchboard are wrong numbers. Find the probability that among 210 calls received by schools switchboard, 4 will be wrong numbers. a). Determine in this case whether the conditions ...

If the results of a t-test lead you to reject the null

If the results of a t-test lead you to reject the null hypothesis, what is the probability that you have made a Type II error?

A bakery was taken to court for selling loaves of bread

A bakery was taken to court for selling loaves of bread that were underweight. These loaveswere advertised as weighing 24 ounces. In its defense, the bakery claimed that the advertisedweight was meant to imply not that e ...

  • 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