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 random sample of the price of gasoline from 40 gas

A random sample of the price of gasoline from 40 gas stations in a region gives the statistics below. Complete parts a) and b). ybar = $3.79, s = $0.27 a) Find a 95% confidence interval for the mean price of regular gaso ...

1 what is the minimum reliability coefficient that

1. What is the minimum reliability coefficient that researchers consider acceptable? Why do researchers use this minimum criterion for reliability? 2. For what kind of measure is it appropriate to examine test-retest rel ...

In this exercise we prove a generalization of brouwers

In this exercise, we prove a generalization of Brouwer's Fixed Point Theorem to compact sets that are not necessarily convex, but are homeomorphic to a convex set. Two compact sets X and Y in R n  are called homeomorphic ...

Determine the linear regression model to predict the cost

Determine the linear regression model to predict the cost of a house. Given that the 145 is the estimated mean value of Y when X is zero and 7.4 is the estimated mean value of Y for every one unit change in X.

1 an investigator wants to determine if a new program aimed

1. An investigator wants to determine if a new program aimed at reducing the overall number of pregnancies in a highly populated area is effective (reducing average births below 6 per household). In order to carry out th ...

Topicnbspstate party structurethreadnbspfirst review the

Topic:  State Party Structure Thread:  First, review the Reading & Study presentation "Political Structure at the State Level" as an example about the structure of the Republican Party in Virginia Select 1 of the major p ...

1 whats so bad about making a type i error2 how does the

1. What's so bad about making a Type I error? 2. How does the Bonferroni adjustment control for Type I error when many statistical tests are conducted? 3. Why do researchers use ANOVA rather than t-tests to analyze data ...

A special industrial battery must have a life of at least

A special industrial battery must have a life of at least 500 hours. A hypothesis test is to be conducted with a 0.04 level of significance. If the batteries from a particular production run have an actual mean use life ...

Describe the technologies that contributed to the

Describe the technologies that contributed to the development and advancement of the newspaper from small, infrequent circulations of a few brief pages to the mass production of daily, extensive pages of news.

A group of statistics students decided to conduct a survey

A group of statistics students decided to conduct a survey at their university to find the average (mean) amount of time students spend studying per week. Based on a simple random sample, they surveyed 45 students. The s ...

  • 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