Question 20
The three figures below (Picture-1, Picture-2, Picture-3) provide the partial regression output from excel for three models (Model-1, Model-2 and Model-3) which were built on the same data (Hint: same dependent variable with same number of rows. However, the number of independent variable in each model is different).
Given this information, answer the subquestions.
ANOVA
| df | SS | MS | F | Significance F | |
|---|---|---|---|---|---|
| Regression | 3 | A1 | 59574.54 | 3177.885 | 5.44128E-10 |
| Residual | 6 | 112.4796 | 18.7466 | ||
| Total | 9 | 178836.1 |
Picture-1: Partial Results from Excel for Model-1
ANOVA
| df | SS | MS | F | Significance F | |
|---|---|---|---|---|---|
| Regression | 2 | 178723.4403 | 5552.402929 | 6.27476E-12 | |
| Residual | 112.6596987 | ||||
| Total | 9 |
| Coefficients | Standard Error | t Stat | |
|---|---|---|---|
| Intercept | 815.7547951 | 4.075009576 | |
| X Variable 1 | -3.952958885 | 0.03846985 | A2 |
| X Variable 2 | 3.664290745 | 0.791804173 |
Picture-2: Partial Results from Excel for Model-2
SUMMARY OUTPUT
| Regression Statistics | |
|---|---|
| Multiple R | 0.998720528 |
| R Square | 0.997442694 |
| Adjusted R Square | 0.99712303 |
| Standard Error | 7.560908499 |
| Observations | 10 |
ANOVA
| df | SS | MS | F | Significance F | |
|---|---|---|---|---|---|
| Regression | 1 | A3 | 3120.29158 | 1.17067E-11 | |
| Residual | 8 | A4 | |||
| Total | 9 | A5 |
Picture-3: Partial Results from Excel for Model-3
What is the value of “A5”? (Note: Enter the answer rounded to two decimal places. For example, if the answer is “1.234”, then enter it as “1.23”)