Business, 28.06.2020 07:01 shyshy1791

A microeconomist wants to determine how corporate sales are influenced by capital and wage spending by companies. She proceeds to randomly select 26 large corporations and record information in millions of dollars. The Microsoft Excel output below shows results of this multiple regression. SUMMARY OUTPUT
Regression Statistics
Multiple-R 0.830
R-Square 0.689
Adjusted-R-Square 0.662
Standard-Error 17501.643
Observations 26
ANOVA
df SS MS F SignF
Regression 2 15579777040 7789888520 25.432 0.0001
Residual 23 7045072780 306307512
Total 25 22624849820
Coeff Std-Error t-Stat P-value
Intercept 15800.0000 6038.2999 2.617 0.0154
Capital 0.1245 0.2045 0.609 0.5485
Wages 7.0762 1.4729 4.804. 0.0001
a. Referring to Table above, what fraction of the variability in sales is explained by spending on capital and wages?
A. 83.0%
B. 68.9%
C. 27.0%
D. 50.9%
b. Referring to Table above, when the microeconomist used a simple linear regression model with sales as the dependent variable and wages as the independent variable, she obtained an r2 value of 0.601. What additional percentage of the total variation of sales has been explained by including capital spending in the multiple regression?
A. 22.9%
B. 31.1%
C. 60.1%
D. 8.8%
c. Referring to Table above, what is the p-value for Capital?
A. 0.05
B. 0.01
C. 0.025
D. None of the above.
Referring to Table above, what are the predicted sales (in millions of dollars) for a company spending $500 million on capital and $200 million on wages?
A. 16,520.07
B. 17,277.49
C. 20,455.98
D. 15,800.00

Answers: 1

Show answers

Other questions on the subject: Business

Business, 22.06.2019 10:40, jonnaevans4856

You were able to purchase two tickets to an upcoming concert for $100 apiece when the concert was first announced three months ago. recently, you saw that stubhub was listing similar seats for $225 apiece. what does it cost you to attend the concert?

Answers: 1

continue

Business, 22.06.2019 17:40, gabe2111

Take it all away has a cost of equity of 11.11 percent, a pretax cost of debt of 5.36 percent, and a tax rate of 40 percent. the company's capital structure consists of 67 percent debt on a book value basis, but debt is 33 percent of the company's value on a market value basis. what is the company's wacc

Answers: 2

continue

Business, 22.06.2019 20:40, leeshaaa17

Spartan credit bank is offering 7.5 percent compounded daily on its savings accounts. you deposit $5,900 today. a. how much will you have in the account in 4 years? (use 365 days a year. do not round intermediate calculations and round your answer to 2 decimal places, e. g., 32.16.) b. how much will you have in the account in 12 years? (use 365 days a year. do not round intermediate calculations and round your answer to 2 decimal places, e. g., 32.16.) c. how much will you have in the account in 19 years?

Answers: 2

continue

Business, 22.06.2019 23:40, step35

When randy, a general manager of a national retailer, moved to a different store in his company that was having difficulty, he knew that sales were low and after talking to his employees, he found morale was also low. at first randy thought attitudes were poor due to low sales, but after working closely with employees, he realized that the poor attitudes were actually the cause of poor sales. randy was able to discover the cause of the problem by utilizing skills.

Answers: 2

continue

You know the right answer?

A microeconomist wants to determine how corporate sales are influenced by capital and wage spending...