Question 4
For the regression output provided in Figure-1, answer the given subquestions.
Note: For all questions in this comprehension, enter your answer in decimals rounded to two decimal places. For example, if your answer is “20.3247” then enter it as “20.32”
SUMMARY OUTPUT
| Regression Statistics | |
|---|---|
| Multiple R | 1 |
| R Square | 1 |
| Adjusted R Square | 1 |
| Standard Error | 1.92403E-15 |
| Observations | A1 |
ANOVA
| df | SS | MS | F | Significance F | |
|---|---|---|---|---|---|
| Regression | A3 | 905.7333333 | A4 | ||
| Residual | 12 | ||||
| Total | 14 |
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
|---|---|---|---|---|---|---|---|---|
| Intercept | 7.10543E-15 | 3.48311E-15 | -4.83607E-16 | 1.46945E-14 | -4.83607E-16 | 1.46945E-14 | ||
| X Variable 1 | 2 | 1.57612E-16 | 2 | 2 | 2 | 2 | ||
| X Variable 2 | 3 | 2.25138E-16 | 3 | 3 | 3 | 3 |
Figure-1: Partial Excel Regression Model Output
How many columns are present in the sample used to develop the regression model (all the columns present in the sample)?