Question

In: Statistics and Probability

The following data represent a company's yearly sales and its advertising expenditure over a period of...

The following data represent a company's yearly sales and its advertising expenditure over a period of 8 years.

Advertising Expenditure (in $10,000) (x)

Sales in
Millions of Dollars (y)

32

15

33

16

34

18

34

17

35

16

37

18

39

21

40

24

a. Develop a scatter diagram of sales versus advertising and explain what it shows regarding the relationship between sales and advertising.
b. Compute an estimated regression equation between sales and advertising.
c. If the company's advertising expenditure is $400,000, what are the predicted sales? Give the answer in dollars.
d. What does the slope of the estimated regression line indicate in the context of this problem?
e. Compute the coefficient of determination and fully interpret its meaning in the context of the problem..
f. Compute the correlation coefficient.

Solutions

Expert Solution

a.

We see that there is increasing trend hence it is positive correlation between x and y

b.

Sum of X = 284
Sum of Y = 145
Mean X = 35.5
Mean Y = 18.125
Sum of squares (SSX) = 58
Sum of products (SP) = 55.5

Regression Equation = ŷ = bX + a

b = SP/SSX = 55.5/58 = 0.9569

a = MY - bMX = 18.13 - (0.96*35.5) = -15.8448

ŷ = 0.9569X - 15.8448

c. For x=40, ŷ = (0.9569*40) - 15.8448=22.4312

d. Slope is the rate change in y corresponding to rate change in x

So for single increase in x, y changes to 0.9569

e.

X Values
∑ = 284
Mean = 35.5
∑(X - Mx)2 = SSx = 58

Y Values
∑ = 145
Mean = 18.125
∑(Y - My)2 = SSy = 62.875

X and Y Combined
N = 8
∑(X - Mx)(Y - My) = 55.5

R Calculation
r = ∑((X - My)(Y - Mx)) / √((SSx)(SSy))

r = 55.5 / √((58)(62.875)) = 0.9191

So r^2=0.8447

So 84.47% of variation in y is explained by x

f. X Values
∑ = 284
Mean = 35.5
∑(X - Mx)2 = SSx = 58

Y Values
∑ = 145
Mean = 18.125
∑(Y - My)2 = SSy = 62.875

X and Y Combined
N = 8
∑(X - Mx)(Y - My) = 55.5

R Calculation
r = ∑((X - My)(Y - Mx)) / √((SSx)(SSy))

r = 55.5 / √((58)(62.875)) = 0.9191


Related Solutions

The following data represent a company's yearly sales and its advertising expenditure over a period of...
The following data represent a company's yearly sales and its advertising expenditure over a period of 8 years. Advertising Expenditure (in $10,000) (x) Sales in Millions of Dollars (y) 32 15 33 16 34 18 34 17 35 16 37 18 39 21 40 24 ​ a. Develop a scatter diagram of sales versus advertising and explain what it shows regarding the relationship between sales and advertising. b. Compute an estimated regression equation between sales and advertising. c. If the...
The following data represent a company's yearly sales and its advertising expenditure over a period of...
The following data represent a company's yearly sales and its advertising expenditure over a period of 8 years. Advertising Expenditure (in $10,000) (x) Sales in Millions of Dollars (y) 32 15 33 16 34 18 34 17 35 16 37 18 39 21 40 24 ​ a. Develop a scatter diagram of sales versus advertising and explain what it shows regarding the relationship between sales and advertising. b. Compute an estimated regression equation between sales and advertising. c. If the...
The following data represent a company's yearly sales and its advertising expenditure over a period of...
The following data represent a company's yearly sales and its advertising expenditure over a period of 8 years. Sales in Millions of Dollars (y)                                       Advertising Expenditure (in $10,000) (x) 15                                                                                            32 16                                                                                            33 18                                                                                            35 17                                                                                            34 16                                                                                            36 19                                                                                            37 19                                                                                            39 24                                                                                            42 a. Use the method of least squares to compute an estimated regression equation between sales and advertising b. If the company's advertising expenditure is $400,000,...
The following data represent a company's yearly sales volume and its advertising expenditure over a period...
The following data represent a company's yearly sales volume and its advertising expenditure over a period of 8 years. Advertising (x) Sales (y) 400,000 6,000,000 500,000 7,200,000 500,000 8,000,000 660,000 7,500,000 790,000 8,900.000 540,000 8,100,000 420,000 5,900.000 380,000 4,000,000 If the company's advertising expenditure is $315,000, what are the predicted sales? If the company wanted $9,500,000 in sales, what should the advertising budget be?
The following data represent a company's yearly sales volume and its advertising expenditure over a period...
The following data represent a company's yearly sales volume and its advertising expenditure over a period of 8 years. Sales in Millions of Dollars Advertising in ($10,000) 11 32 16 33 18 35 17 34 16 36 19 37 19 39 24 42 a. Which variable is the dependent variable? b. Using the Excel spreadsheet, run the least squares model and write the summary output here. c. If the company's advertising expenditure is $400,000, what are the predicted sales? Give...
The following data represent a company's yearly sales volume and its advertising expenditure over a period...
The following data represent a company's yearly sales volume and its advertising expenditure over a period of 8 years. (Y) Sales in Millions of Dollars (X) Advertising in ($10,000) 14 32 15 33 18 35 17 34 16 36 a. Develop a scatter diagram of sales versus advertising and explain what it shows regarding the relationship between sales and advertising. b. Use the method of least squares to compute an estimated regression line between sales and advertising. c. If the...
The following data represent a company's yearly sales volume and its advertising expenditure over a period...
The following data represent a company's yearly sales volume and its advertising expenditure over a period of 8 years.                                                 (Y)                                          (X)         Sales in millions                     Advertising in ($10,000)                                                 15                                            32                                                 16                                            33                                                 18                                            35                                                 17                                            34                                                 16                                            36 (a) Develop a scatter diagram of sales versus advertising and explain what it shows regarding the relationship between sales and advertising. (b) Use the method of least squares to compute an estimated regression line between sales and...
The following data represent a company's yearly sales volume and its advertising expenditure over a period...
The following data represent a company's yearly sales volume and its advertising expenditure over a period of 8 years.              Sales (Millions) Advertising ($10,000) 15 32 16 33 18 35 17 34 16 36 19 37 19 39 24 42 To make sure the Excel regression package is installed. Click “Tools”, à“Add-Ins” àchoose “Analysis Toolpak” and click “OK”. To use the Excel regression package,                                                      Click “Tools”, à“Data Analysis” and click “Regression”.                                                                          a.   Use the method of least squares to compute...
The following data represent a company's yearly sales volume and its advertising expenditure over a period...
The following data represent a company's yearly sales volume and its advertising expenditure over a period of 5 years. (Y) Sales in Millions of Dollars 15 16 18 17 16 (X) Advertising in ($10,000) 32 33 35 34 36 (a) Compute the coefficient of determination for the estimated regression equation you got in the previous in-class problem. (b) Interpret the meaning of the value of the coefficient of determination that you found in (a). Be very specific. (c) Perform a...
The following data represent a company's yearly sales volume and its advertising expenditure over a period...
The following data represent a company's yearly sales volume and its advertising expenditure over a period of 5 years. (Y) Sales in Advertising (X) Millions of Dollars in ($10,000) 15 32 16 33 18 35 17 34 16 36 (a) Develop a scatter diagram of sales versus advertising and explain what it shows regarding the relationship between sales and advertising. (b) Use the method of least squares to compute an estimated regression line between sales and advertising by computing b0...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT