In: Statistics and Probability
We are interested in studying the linear relationship between someone's age and how much they spend on travel. The following data is provided:
| Amount Spent on Travel | Age |
| 850 | 39 |
| 997 | 43 |
| 993 | 50 |
| 649 | 59 |
| 1265 | 25 |
| 680 | 38 |
Find SST.
| a. |
667.33 |
|
| b. |
153,844.05 |
|
| c. |
264,991.33 |
|
| d. |
196.11 |
We are interested in studying the linear relationship between someone's age and how much they spend on travel. The following data is provided:
| Amount Spent on Travel | Age |
| 850 | 39 |
| 997 | 43 |
| 993 | 50 |
| 649 | 59 |
| 1265 | 25 |
| 680 | 38 |
Find SSR.
| a. |
153,844.05 |
|
| b. |
111,147.2 |
|
| c. |
264,991.33 |
|
| d. |
667.33 |
using excel data analysis tool for regression,steps are: write
data>menu>data>data analysis>regression>enter
required labels>ok> and following o/p is obtained
| Regression Statistics | ||||||
| Multiple R | -0.6476 | |||||
| R Square | 0.4194 | |||||
| Adjusted R Square | 0.2743 | |||||
| Standard Error | 196.1148 | |||||
| Observations | 6 | |||||
| ANOVA | ||||||
| df | SS | MS | F | Significance F | ||
| Regression | 1 | 111147.2 | 111147.3 | 2.89 | 0.1644 | |
| Residual | 4 | 153844.1 | 38461.0 | |||
| Total | 5 | 264991.33 | ||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | |
| Intercept | 1452.0035 | 331.2046 | 4.3840 | 0.0118 | 532.4321 | ######### |
| X | -12.9056 | 7.5917 | -1.7000 | 0.1644 | -33.9835 | 8.1723 |
from here,
SST= 264991.33
SSR = 111,147.2