Question: Fill in all the blanks below to complete the partial Excel output for a linear regression between the independent variable x and the dependent variable
Fill in all the blanks below to complete the partial Excel output for a linear regression between the independent variable x and the dependent variable y.
| Regression Statistics | |
|---|---|
| Multiple R | 0.1364 |
| R Square | (Round to 4 decimal places) |
| Standard Error | 3.4132 |
| Observations |
| df | SS (Round to 4 decimal places) | MS (Round to 2 decimal places) | F (Round to 2 decimal places) | Significance F | |
|---|---|---|---|---|---|
| Regression | 2.6500 | 0.6420 | |||
| Residual | 11.65 | ||||
| Total | 13 |
| Coefficients | Standard Error | t Stat (Round to 3 decimal places) | P-value | |
|---|---|---|---|---|
| Intercept | 8.3 | 2.2187 | 0.0028 | |
| x | 0.28 | 0.5801 | 0.6420 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
