Explore BrainMass
Share

Multiple Regression - Vanguard Corporation

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

The director of marketing at Vanguard Corporation believes that sales of the company's Bright Side laundry detergent (S) are related to Vanguard's own advertising expenditure (A), as well as the combined advertising expenditures of its three biggest rival detergents (R). The marketing director collects 36 weekly observations on S,A, and R to estimate the following multiple regression equation:

S = a + bA+cR

Where S,A and R are measured in dollars per week. Vanguard's marketing director is comfortable using parameter estimates that are statistically significant at the 10 percent level or better.

a. What sign does the marketing director expect a, b, and c to have?
b. Interpret the coefficients a, b and c.

The regression output from the computer is as follows:

DEPENDENT VARIABLE: S R-SQUARE F-RATIO P-VALUE ON F
OBSERVATIONS: 36 0.2247 4.781 0.0150
VARIABLE PARAMETER ESTIMATE STANDARD ERROR T-RATIO P-VALUE
INTERCEPT 175086.0 63821.0 2.74 0.0098
A 0.8550 0.3250 2.63 0.0128
R -0.284 0.164 -1.73 0.0927

c. Does Vanguard's advertising expenditure have a statistically significant effect on the sales of Bright Side detergent? Explain, using the appropriate p-value.

d. Does advertising by its three largest rivals affect the sales of Bright Side detergent in a statistically significant way? Explain, using the appropriate p-value.

e. What fraction of the total variation in sales of Bright Side remains unexplained? What can the marketing director do to increase the explanatory power of the sales equation? What other explanatory variables might be added to this equation?

f. What is the expected level of sales each week when Vanguard spends \$40,000 per week and the combined advertising expenditures for the three rivals are \$100,000 per week.

https://brainmass.com/economics/regression/multiple-regression-vanguard-corporation-259099

\$2.19

Multiple Regression for Vanguard Corp

The director of a marketing at Vanguard Corp believes that sales of the company's bright side laundry detergent (s) are related to Vanguard's own advertising expenditure (a), as well as the combined advertising expenditures of its three biggest rival detergents (r).
The marketing director collects 36 weekly observations on S, A, and R to estimate the following multiple regression equation:
S= a + bA + cR
where S, A and R are measured in dollars per week, Vanguard;s marketing director is comfortable using parameter estimates that are statistically significant at the 10 percent level or better.

a). what sign does the marketing director expect a, b and c to have?
b). interpret the coefficients a, b and c.
The regression output from the computer is as follows:

Dependent Variable : S R Squared F Ratio P Value on F
Observations 36 0.2247 4,781 0.0150

Variable Parameter Estimate Standard Error T Ratio P Value

Interception 175086.0 63821.0 2.74 0.0098
A 0.8550 0.3250 2.63 0.0128
R -0.284 0.164 - 1.73 0.0927

c). Does vanguard's advertising expenditure have a statistically significant effect on the sales of bright side detergent? explain using the appropriate p value.
d). what fraction of the total variation in sales of bright side remains unexplained? what can the marketing director do to increase the explanatory power of the sales equation? what other explanatory variables might be added to this equation?
e). what is he expected level of sales each week when vanguard spends \$40,000 per week and the combined advertising expenditures for the three rivals are \$100,000 per week?

View Full Posting Details