Reference no: EM13244783
A CEO of a large plastics manufacturing company would like to determine if she should be placing more money allotted in the budget next year for television advertising of a new baby bottle marketed for controlling reflux and reducing gas. She wonders whether there is a strong relationship between the amount of money spent on television advertising for this new baby bottle called Gentle Bottle and the number of orders received. The manufacturing process of this baby bottle is very difficult and requires advanced quality control 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 baby bottle. 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:
Month
|
Advertising Cost
|
Number of Orders
|
1
|
$77,430.00
|
2,902,000
|
2
|
62,620
|
3,800,000
|
3
|
69,580
|
3,299,000
|
4
|
50,670
|
2,430,000
|
5
|
69,180
|
3,367,000
|
6
|
73,140
|
4,011,000
|
7
|
83,370
|
4,888,000
|
8
|
78,880
|
4,935,000
|
9
|
64,990
|
5,555,000
|
10
|
77,230
|
4,654,000
|
11
|
61,380
|
5,598,000
|
12
|
62,900
|
2,967,000
|
13
|
63,270
|
2,899,000
|
14
|
89,190
|
4,245,000
|
15
|
60,030
|
4,934,000
|
16
|
79,210
|
3,853,000
|
17
|
65,770
|
5,625,000
|
18
|
84,530
|
5,778,000
|
19
|
79,760
|
5,999,000
|
20
|
82,640
|
6,834,000
|
a. Set up a scatter diagram and calculate the associated correlation coefficient. Discuss how strong you think the relationship is between the amount of money spent on television advertising and the number of orders received. Please use the Correlation procedures within Excel under Tools > Data Analysis. The Scatterplot 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. 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.
c. Interpret the meaning of the slope, b1, in the regression equation.
d. Predict the monthly advertising cost when the number of orders is 4,800,000.
e. Compute the coefficient of determination, r2, and interpret its meaning.
f. Compute the standard error of estimate, and interpret its meaning.
g. Do you think that the company should use these results from the regression to base any corporate decisions on?....explain fully.
Describe how each of events would change the equilibrium
: (a) The government announces that the tax rate on laborincome will rise in the future. (b) An earthquake reduces the capital stock by10%. (c) A stock market boom raises people's wealth.
|
Explain a system where equal masses of aluminum
: Which of the following states are Ture of the final temperature of a system where equal masses of Aluminum( Cal=0.900 J/g Celsius, Ti=75 Celsius and water (ch2o=4.284j/gcel, Ti=25 cel) are placed in contact? assume no energy losses to the surround..
|
In the 1960s change was occurring around the globe
: In the 1960s change was occurring around the globe. Choose any two countries other than the United States and do research to find out what kinds of change were taking place there. (most should be in one's own words, with the exception of the cited).
|
Explain the total pressure in the flask measured
: 03 mol sample of NH4NO3 is placed in a 1L evacuated flask, which is then sealed and heated. The NH4NO3 decomposes completely accodring to the balanced equation: NH4NO3-->N20+2H20 The total pressure in the flask measured at 400K is closest to which ..
|
Compute the coefficient of determination
: Compute the coefficient of determination and interpret its meaning and compute the standard error of estimate, and interpret its meaning.
|
Ramifications-such as political-religious and sociologically
: What impact or significance did the Enlightenment have on America in all of its ramifications, such as political, religious, and sociologically?
|
Explain the molar mass of fes2
: Determine the volume of SO2 (at STP) formed from the reaction of 96.7g of FeS2 and 55.0 L of O2 (at 398K and 1.20 atm). The molar mass of FeS2 is 119.99 g/mol.
|
Social conduct-gender relations and human sexuality
: This assignment is to analyse a primary source which is the vatsyana's kama sutra. Who produced the source? When, where, how, why, and for whom? What form does it take? What are its assumptions? What trends in thought does it engage? What language an..
|
Influences stock buyback programs
: Companies that are smart and conservative about their buybacks are not just creating value by maximizing float reduction, but they are also signaling to investors that they are likely well managed in other ways
|