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

Another question on Business

Business, 21.06.2019 20:10

In three to four sentences, explain the effect of a price ceiling on the quantity of a good and who this intervention intends to assist

Answers: 3

Answer

Business, 22.06.2019 12:10

Profits from using currency options and futures.on july 2, the two-month futures rate of the mexican peso contained a 2 percent discount (unannualized). there was a call option on pesos with an exercise price that was equal to the spot rate. there was also a put option on pesos with an exercise price equal to the spot rate. the premium on each of these options was 3 percent of the spot rate at that time. on september 2, the option expired. go to the oanda.com website (or any site that has foreign exchange rate quotations) and determine the direct quote of the mexican peso. you exercised the option on this date if it was feasible to do so. a. what was your net profit per unit if you had purchased the call option? b. what was your net profit per unit if you had purchased the put option? c. what was your net profit per unit if you had purchased a futures contract on july 2 that had a settlement date of september 2? d. what was your net profit per unit if you sold a futures contract on july 2 that had a settlement date of september 2

Answers: 1

Answer

Business, 22.06.2019 17:30

Dr. sperry, a biologist, is using excel to track growth rates of different populations of bacteria. she has a very complex formula in one cell. it begins with “round”. dr. sperry would like to see exactly how excel’s calculation reached the final rounded value that she sees in the cell. what could dr. sperry do to best understand how the calculation was made? try different formulas on her own until she reaches the value shown in excel click on the evaluate formula button in the formulas tab and then click “step in” select the cell and then look at the formula in the formula field of the ribbon remove “round” from the formula in order to see the actual value before rounding

Answers: 2

Answer

Business, 22.06.2019 18:00

Your subscription to investing wisely weekly is about to expire. you plan to subscribe to the magazine for the rest of your life, and you can renew it by paying $85 annually, beginning immediately, or you can get a lifetime subscription for $620, also payable immediately. assuming that you can earn 6.0% on your funds and that the annual renewal rate will remain constant, how many years must you live to make the lifetime subscription the better buy?

Answers: 2

Answer

You know the right answer?

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

Questions