Reference no: EM131047696
Question- 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 Excel output is shown below:
ANOVA
df SS MS F
Regression 321.11
Residual 63.39
| |
Coefficients
|
Standard Error |
|
Intercept
|
7.0174
|
1.8972
|
|
x1
|
8.6233
|
2.3968
|
|
x2
|
0.0858
|
0.1845
|
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 alpha = 0.01, 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 alpha = 0.01, test to see if the coefficient of x1 is significantly different from zero.
e. At alpha = 0.01, test to see if the coefficient of x2 is significantly different from zero.
f. Determine the multiple coefficient of determination.
g. Compute the adjusted coefficient of determination.
|
What is the current price of the firms stock
: Dartsch Corporation just paid a dividend of euro 1.45. Dartsch is expected to increase its dividend by 12 percent for the next five years, thereafter the firm's dividends are expected to grow at a more modest rate of 4 percent indefinitely. If the re..
|
|
Create a gantt chart illustrating the project tasks
: Create a Gantt chart illustrating the project tasks. Create a system diagram illustrating the equipment and connections required for this project (use Microsoft Visio or a similar software package).
|
|
Most ratios are difficult to interpret in isolation
: Most ratios are difficult to interpret in isolation, but which of the following is almost certainly Bad News, especially if the general economy is in excellent condition?
|
|
Advantage of transitioning firm from private business
: Which of the following is NOT generally considered an advantage of transitioning a firm from a private business to a public corporation, despite the time and expense required to do so?
|
|
Write regression equation that can be used to predict sales
: Use the above results and write the regression equation that can be used to predict sales. Estimate the sales volume for an advertising expenditure of 3.5 million dollars and 45 salespeople. Give your answer in dollars
|
|
Decision when raising capital
: Which of the following is NOT a Stage II decision when raising capital
|
|
Identical sales and identical operating profit margins
: Firms A and B have identical Sales and identical operating profit margins but B has a smaller net profit margin. Which of the following is the most likely explanation?
|
|
Gross profit margin is much larger than the other firms
: ABC Corporation Corporation's (a large manufacturing firm) gross profit margin is much larger than the other firms in the industry. Which of the following is the most likely explanation?
|
|
Calculating the cost of equity
: Calculating the Cost of Equity Smaltz Enterprises is currently involved in its annual review of the firm’s cost of capital. Historically, the firm has relied on the CAPM to estimate its cost of equity capital. Estimate Smaltz’s cost of equity capital..
|