Are the weeks on the market higher or lower for the company than
tutor4helpyou
excel_sheet.xlsx
Sheet1
| Asking Price | Weeks on Market |
| 60 | 6 |
| 80 | 7 |
| 100 | 8 |
| 150 | 12 |
| 85 | 7 | | | | SUMMARY OUTPUT |
| 120 | 8 |
| 200 | 12 | | | | Regression Statistics |
| 80 | 6 | | | | Multiple R | 0.9485 |
| 400 | 22 | | | | R Square | 0.8996 |
| 75 | 8 | | | | Adjusted R Square | 0.8940 |
| 90 | 10 | | | | Standard Error | 1.4867 |
| 300 | 16 | | | | Observations | 20 |
| 160 | 14 |
| 70 | 5 | | | | ANOVA |
| 90 | 6 | | | | | df | SS | MS | F | Significance F |
| 300 | 18 | | | | Regression | 1 | 356.4155 | 356.4155 | 161.2558 | 0.0000 |
| 120 | 9 | | | | Residual | 18 | 39.7845 | 2.2102 |
| 240 | 14 | | | | Total | 19 | 396.2 |
| 65 | 7 |
| 95 | 11 | | | | | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% |
| | | | | | Intercept | 3.7711 | 0.6123 | 6.1593 | 0.0000 | 2.4848 | 5.0574 | 2.4848 | 5.0574 |
| | | | | | Asking Price | 0.0453 | 0.0036 | 12.6987 | 0.0000 | 0.0378 | 0.0528 | 0.0378 | 0.0528 |