Question

A paper described a study that examined whether stress accelerates aging at a cellular level. The accompanying data on a measure of perceived stress (x) and telomere length (y) were read from a scatterplot that appeared in the paper. Telomere length is a measure of cell longevity. Perceived stress Telomere length Perceived stress Telomere length 5 1.06 20 2.1 6 1.1 20 1.14 6 1.18 20 0.98 7 1.02 21 1.14 10 1.9 21 2.14 11 1.46 21 1.66 12 1.02 22 1.78 13 1.58 22 2.26 14 1.3 22 0.9 14 0.94 23 2.42 15 1.98 24 1.1 15 1.62 24 1.66 15 1.7 25 2.14 17 1.14 26 1.26 17 1.06 27 1.98 17 1.78 27 2.34 18 1.38 28 1.34 18 1.62 29 2.22 19 1.94 33 0.94 (

a) Compute the equation of the least-squares line. (Round all answers to the nearest thousandth.) y hat =

(b) What is the value of r2?

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.3276
R Square	0.1074
Adjusted R Square	0.0826
Standard Error	0.4436
Observations	38
ANOVA
	df	SS	MS	F	Significance F
Regression	1	0.9	0.9	4.33	0.0446
Residual	36	7.1	0.1968
Total	37	7.9
	Coefficients	Standard Error	t Stat	P-value	lower 90%	upper 90%
Intercept	1.120	0.211	5.298	0.0000	0.7631	1.477
X	0.022	0.011	2.081	0.0446	0.0042	0.0404

a)  Ŷ =   1.120   +   0.022   *x

b)  R² =     0.1074