Calculate the coefficient of determination

Assignment Help Mathematics
Reference no: EM1321077

Question: A CEO of a large pharmaceutical company would like to determine 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 process 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. Please carefully read the example below and try to answer the questions in terms of the problem context. The results are as follows:

a. Set up a scatter diagram and calculate the associated correlation coefficient. Discuss how strong you think the relationship is between the amounts of money spent on television advertising and the number of orders received. Please use the Correlation procedures within Excel under Tools > Data Analysis. The Scatter plot can more easily be generated using the Chart procedure.

NOTE: If you do not have the Data Analysis option under Tools you must install it. You need to go to Tools select Add-ins and then choose the 2 data toolpak options. The original Excel CD will be required for this installation. It should take about a minute.

b. Assuming there is a statistically significant relationship, use the least squares method to find the regression equation to predict the advertising costs based on the number of orders received. Please use the regression procedure within Excel under Tools > Data Analysis to construct this equation.

Month

Advertising Cost (thousands of dollars)

Number of Orders

1

$58.93

4,102,000

2

70.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

4,111,000

7

73.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,398,000

12

52.9

2,967,000

13

61.27

3,999,000

14

79.19

4,345,000

15

60.03

3,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

[A] Predict the monthly advertising cost when the number of orders is 4,999,000. [Hint: Be very careful with assigning the dependent variable for this problem]

[B] Calculate the coefficient of determination, r2, and interpret its meaning.

[C] Calculate the standard error of estimate, and interpret its meaning.

[D] Interpret the meaning of the slope, b1, in the regression equation.

 

 

 

 

Reference no: EM1321077

Questions Cloud

Calculate the probability that the return for common stocks : Calculate the probability that the return for common stocks
Calculate a 95% confidence interval for the population mean : Calculate a 95 percent confidence interval for the population mean
Give examples for regression and analysis : Explain how regression and analysis can be used to test a Survey?
Dual degree students are receiving lower : the dual degree students are receiving lower grades? Explain your answer to receive full credit.
Calculate the coefficient of determination : Calculate the coefficient of determination
What must be the odds against outcome : What must be the odds against outcome four if there is to be no possible arbitrage when one is allowed to bet both for & against any of the outcomes?
Exponentials depending on the random variable : Exponentials depending on the random variable
Solving problems on probability : Solving problems on probability.
Find the probability on randomly chosen employee : What is the probability that a randomly chosen employee who has not had graduate training is a woman?

Reviews

Write a Review

Mathematics Questions & Answers

  Questions on ferris wheel

Prepare a Flexible Budget Gator Divers is a company that provides diving services such as underwater ship repairs to clients in the Tampa Bay area.

  Logistic map

This assignment has two question related to maths. Questions are related to bifurcation cascade and logistic map.

  Finding the probability of cards

This assignment has questions related to probabiltiy.

  Systems of ode

Find all the xed points, and study their stability and Draw the phase portrait of the system, as well as the graphs of the solutions in all relevant cases.

  Derive the boolean expression

Derive the Boolean Expression and construct the switching circuit for the truth table stated

  System of equations

Evaluate which equations are under-identified, just-identified, and over-identified.

  Linear programming problem

Linear programming problem consisting of only two constraints with one objective function.

  Find the natural domain

Find the natural domain of the given functions.

  Introduction to numerical methods

Compute the coecients of the polynomials using the term recurrence relation.

  Chart of the topological manifold

De?nition of smoothness of functions on a smooth manifold is chart independent and hence geometric.

  Mathematics in computing

Questions related on mathematics in computing.

  Complex problems

Complex problems

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd