Question

1. 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

2. 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

Answer 1

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