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

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?

Marjorie bought a home with an adjustable-rate mortgage the

Marjorie bought a home with an adjustable-rate mortgage. The margin on an adjustable-rate mortgage is 2.5% and the rate cap is 7% over the life of the loan. If the current index rate is 5.9%, what is the calculated inter ...

A researcher was interested in whether people tend to marry

A researcher was interested in whether people tend to marry individuals who are about the same level of physical attractiveness as they are. She took individual photographs of 14 pairs of spouses. Then, she had 10 partic ...

You have been asked to evaluate the effects of a new

You have been asked to evaluate the effects of a new educational video that was developed to reduce racial prejudice among adolescents. You plan to administer a pretest measure of racial attitudes to 60 adolescent partic ...

Tell which measures are resistant to outliers and which are

Tell which measures are resistant to outliers and which are NOT resistant to outliers from the following list, and explain WHY or WHY NOT for each measure: Mean, median, Quartiles, correlation, and standard deviation.

Explain i the hypotheses with a plausible definition of p

Explain (i) the hypotheses with a plausible definition of p or µ, (ii) whether or not the data indicate practical significance (use common sense and/or general knowledge), and (iii) whether or not the data indicate stati ...

In a pulse rate research a simple random sample of 120 men

In a pulse rate research, a simple random sample of 120 men results in a mean of 80 beats per minute, and a standard deviation of 11 beats per minute. Based on the sample results, the researcher concludes that the pulse ...

A real number x is randomly chosen from the interval 010

A real number X is randomly chosen from the interval [0,10], dividing the interval into a left and a right side. Find the probability that the left side is at least four times as big as the right.

A national survey of 40000 adults in the us in 1992 found

A national survey of 40,000 adults in the US in 1992 found that 26% of adults were current smokers. A similar survey of 37,000 adults in the US in 1966 found that 43% of adults were current smokers. Construct a 95% confi ...

What issues did the third world radicalism address how

What issues did the third world radicalism address? How successful were their leaders in implementing their goals? Answer has to be a page minimum

  • 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