Solved

In Order to Determine Whether or Not the Sales Volume

Question 111

Essay

In order to determine whether or not the sales volume of a company (Y in millions of dollars) is related to advertising expenditures (X1 in millions of dollars) and the number of salespeople (X2), data were gathered for 10 years. Part of the regression results is shown below. In order to determine whether or not the sales volume of a company (Y in millions of dollars) is related to advertising expenditures (X<sub>1</sub> in millions of dollars) and the number of salespeople (X<sub>2</sub>), data were gathered for 10 years. Part of the regression results is shown below. a. Use the above results and write the regression equation that can be used to predict sales. b. Estimate the sales volume for an advertising expenditure of 3.5 million dollars and 45 salespeople. Give your answer in dollars. c. At  = 0.05, test to determine if the fitted equation developed in Part a represents a significant relationship between the independent variables and the dependent variable.d. At  = 0.05, test to see if 1 is significantly different from zero. e. Determine the multiple coefficient of determination. f. Compute the adjusted coefficient of determination. In order to determine whether or not the sales volume of a company (Y in millions of dollars) is related to advertising expenditures (X<sub>1</sub> in millions of dollars) and the number of salespeople (X<sub>2</sub>), data were gathered for 10 years. Part of the regression results is shown below. a. Use the above results and write the regression equation that can be used to predict sales. b. Estimate the sales volume for an advertising expenditure of 3.5 million dollars and 45 salespeople. Give your answer in dollars. c. At  = 0.05, test to determine if the fitted equation developed in Part a represents a significant relationship between the independent variables and the dependent variable.d. At  = 0.05, test to see if 1 is significantly different from zero. e. Determine the multiple coefficient of determination. f. Compute the adjusted coefficient of determination.
a. Use the above results and write the regression equation that can be used to predict sales.
b. Estimate the sales volume for an advertising expenditure of 3.5 million dollars and 45 salespeople. Give your answer in dollars.
c. At  = 0.05, test to determine if the fitted equation developed in Part a represents a significant relationship between the independent variables and the dependent variable.d. At  = 0.05, test to see if 1 is significantly different from zero.
e. Determine the multiple coefficient of determination.
f. Compute the adjusted coefficient of determination.

Correct Answer:

verifed

Verified

a. blured image = 7.0174 + 8.6233X1 + 0.0858X2
b.$41,0...

View Answer

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q89: In a regression model involving more than

Q106: A regression model in which more than

Q107: Sherri Cola Company has developed a

Q108: In a multiple regression analysis involving 5

Q109: Exhibit 15-8<br>The following estimated regression model was

Q110: The following regression model has been proposed

Q112: A regression was performed on a sample

Q113: In multiple regression analysis, the correlation among

Q114: In a regression model involving 46 observations,

Q115: Exhibit 15-2<br>A regression model between sales (Y