Part of an Excel output relating x (independent variable) and y (dependent variable) is shown below. Fill in all the blanks marked with "?".
Summary Output Regression StatisticsMultiple R?
R Square0.5149
Standard Error7.3413
Observations11
?
ANOVA      df
SS
MS
F
Significance F
Regression?
?
?
?
0.0129
Residual?
?
?
  Total?
1000
   ?
 Coefficients
Standard Error
t Stat
P-value
Intercept?
29.4818
 3.7946
0.0043
x?
  0.7000
-3.0911
0.0129

What will be an ideal response?


?

Summary Output
 
Regression Statistics
Multiple R0.7176
R Square0.5149
Standard Error7.3413
Observations11
?
ANOVA     
 dfSSMSFSignificance F
Regression  1  514.9514.99.550.0129
Residual  9  485.1  53.9  
Total101000.0   
?
 CoefficientsStandard Errort StatP-value
Intercept111.871629.4818 3.79460.0043
x   -2.1638  0.7000-3.09110.0129

Business

You might also like to view...

Which of the following statements is FALSE about brainwriting?

a. Individuals generate their ideas in writing. b. It is an effective alternative to traditional brainstorming. c. It combines the benefits of individual and group creativity. d. It cannot be conducted virtually.

Business

Typical titles of first-line managers include foreman and section leader.

Answer the following statement true (T) or false (F)

Business

Which of the following statements is true of successful firms?

A. They overlookthe overall sense of well-being experienced by their customers. B. They focus on the price of a good rather than on the benefits offered. C. Theydeliver unsurpassedvalueto their customers. D. Their core goal is to generate short-term profits.

Business

All of the following statements about long-term care insurance are true EXCEPT

A) Premiums can be reduced by electing shorter elimination periods. B) A common benefits trigger is the inability to perform a certain number of activities of daily living. C) Protection against inflation is usually made available as an optional benefit. D) Policies currently sold are guaranteed renewable.

Business