Question

In: Statistics and Probability

A department store investigated the effects of advertising expenditure on the weekly sales for its men's...

A department store investigated the effects of advertising expenditure on the weekly sales for its men's wear, children's wear, and women's wear departments. Five weeks were randomly selected for each department to be used in the analysis (this makes 15 weeks in total, ?n). The variables are as follows:

?y = weekly sales
?1x1 = advertising expenditure
?2x2 = 1 if it is the children's wear department and a 0 otherwise
?3x3 = 1 if it is the women's wear department and a 0 otherwise

The manager in charge of the department store wants to see if separating by the type of department is significant to the model. The current model is:
?̂ =?0+?1?1+?2?2+?3?3

a) Test whether the part of the model which concerns the departments is significant or not using ?=0.05α=0.05 and the tables below.

Complete model:

Source df SS MS F
Regression 3 41.268 13.756 9.067
Error 11 16.689 1.517
Total 14 57.957


Reduced model:

Source df SS MS F
Regression 1 0.867 0.867 0.197
Error 13 57.090 4.392
Total 14 57.957

1. ?0:H0:   B0 = B1 = B2 = B3 = 0 B1 = B2 = B3 = 0 B2 = B3 = 0 B1 = B2 = 0 B0 = 0 B1 = 0 B2 = 0 B3 = 0  vs ??:Ha:   B1 /= 0 At least one of the B's are not 0 B2 /= 0 B3 /= 0 B0 /= 0
2. Test statistic: F =
3. Critical value: ??Fα =
4. Conclusion:  ?0H0. (Type either Reject or Fail to reject)
There  evidence that the part of the model which concerns the departments is significant. (Type either is or is not)

Solutions

Expert Solution

1.

x2 and x3 are the coefficients which concerns the departments.

So, the null and alternative hypothesis are,

H0:  B2 = B3 = 0

Ha: B2 /= 0 or B3 /= 0

2.

F = ((SSER - SSEF)/q ) / (SSEF / (n-k-1))

where SSER, SSEF are SS Error for reduced and full model.

q is number of coefficients in the null hypothesis

n is number of observations and k is number of predictors in full model

F = ((57.090 - 16.689)/2 ) / (16.689 / (15-3-1)) = 13.31449

3.

Degree of freedom = q, n-k-1 = 3, 15-3-1 = 3, 11

Critical value: Fα at α=0.05 and df = 3, 11 is   3.587

4.

Since the observed F statistic is greater than the critical value,

Reject H0.

There is evidence that the part of the model which concerns the departments is significant.


Related Solutions

A chain store corporation wants study the effects of price decrease (x1, in %) and advertising expenditure increase (x2) on sales volume (y).
  A chain store corporation wants study the effects of price decrease (x1, in %) and advertising expenditure increase (x2) on sales volume (y). The corporation imposes different levels of price decrease and advertising expenditure increase on its product in stores in eight different districts of the country and measures the changes in sales volume over the next three months. A multiple regression model is used and the following output is extracted from the computer software. ANOVA   df SS...
1 A department store has budgeted sales of 12,700 men's coats in September. Management wants to...
1 A department store has budgeted sales of 12,700 men's coats in September. Management wants to have 6,700 coats in inventory at the end of the month to prepare for the winter season. Beginning inventory for September is expected to be 4,700 coats. What is the dollar amount of the purchase of suits if each coat has a cost of $82. 2. A company's history indicates that 30% of its sales are for cash and the rest are on credit....
Assume Monthly Advertising Expenditure is the independent variable. Store Monthly Profit Monthly Advertising expenditure A1 $13,593.02...
Assume Monthly Advertising Expenditure is the independent variable. Store Monthly Profit Monthly Advertising expenditure A1 $13,593.02 $1,710.00 A2 $23,896.73 $1,983.00 A3 $9,932.64 $952.00 A4 $9,100.41 $1,009.00 A5 $15,220.08 $2,315.00 A6 $33,900.67 $2,197.00 A7 $6,935.36 $934.00 A8 $10,112.62 $2,375.00 A9 $9,155.14 $1,065.00 A10 $8,513.94 $812.00 A11 $7,933.25 $1,052.00 A12 $11,388.13 $2,234.00 A13 $26,299.72 $2,962.00 A14 $21,423.87 $1,699.00 A15 $21,430.21 $1,991.00 A16 $19,984.96 $2,181.00 A17 $11,575.09 $1,831.00 A18 $18,900.44 $1,819.00 A19 $21,815.24 $2,394.00 A20 $35,642.73 $2,296.00 What is the sum of squares...
1. An average department store sells 350 men's suits per year. The men's suit departments at...
1. An average department store sells 350 men's suits per year. The men's suit departments at a particular national chain of stores claim they sell more than the industry average. In 45 of their stores, they sold, on the average, 450 suits per year with a population standard deviation of 50. What is the test value for their claim? 2. The average speed of greyhound dogs is about 18.7 meters per second. A particular greyhound breeder claims that her dogs...
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. 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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT