PLEASE SOLVE AND ANSWER Use MS Excel to make the scatterplots and to verify the determined least-squares line using its
Posted: Mon May 16, 2022 8:06 am
PLEASE SOLVE AND ANSWER
Use MS Excel to make the scatterplots and to verify the determined least-squares line using its Trendline function.
5.38 . The paper "Accelerated Telomere Shortening in Response to Life Stress" (Proceedings of the National Academy of Sciences [2004]: 17312-17315) 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.25 20 1.22 6 1.32 20 1.30 6 1.5 1.32 20 21 7 1.35 1.24 10 1.3 21 1.26 11 1 21 1.30 1.18 22 12 13 1.18 1.22 1.1 22 14 1.08 1.24 22 23 14 1.3 15 0.92 24 1.18 1.12 1.50 0.94 15 1.22 ৪ 24 15 1.24 25 1.12 17 17 17 1.32 26 27 27 28 0.84 1.02 1.12 1.22 1.4 1.12 18 18 1.46 29 1.30 19 0.84 33 0.94 a. Compute the equation of the least-squares line. b. What is the value of r?? c. Does the linear relationship between perceived stress and telomere length account for a large or small proportion of the variability in telomere length? Justify your answer.
Use MS Excel to make the scatterplots and to verify the determined least-squares line using its Trendline function.
- Please Solve And Answer Use Ms Excel To Make The Scatterplots And To Verify The Determined Least Squares Line Using Its 1 (33.98 KiB) Viewed 41 times
- Please Solve And Answer Use Ms Excel To Make The Scatterplots And To Verify The Determined Least Squares Line Using Its 2 (39.44 KiB) Viewed 41 times
Perceived Stress Telomere Length Perceived Stress Telomere Length 5 1.25 20 1.22 6 1.32 20 1.30 6 1.5 1.32 20 21 7 1.35 1.24 10 1.3 21 1.26 11 1 21 1.30 1.18 22 12 13 1.18 1.22 1.1 22 14 1.08 1.24 22 23 14 1.3 15 0.92 24 1.18 1.12 1.50 0.94 15 1.22 ৪ 24 15 1.24 25 1.12 17 17 17 1.32 26 27 27 28 0.84 1.02 1.12 1.22 1.4 1.12 18 18 1.46 29 1.30 19 0.84 33 0.94 a. Compute the equation of the least-squares line. b. What is the value of r?? c. Does the linear relationship between perceived stress and telomere length account for a large or small proportion of the variability in telomere length? Justify your answer.