The age in years and the number of hours of sleep in one night for seven adults.
Age,x 35,20,59,42,68,38,75
Hrs of sleep,y 7,9,5,6,5,8,4
1. Use excel to do a scatter plot. Remember your title and axis titles.
2. Caculate the correlation coefficient r using excel
3. What is R to the power of 2?
4. calculate the slope,m, of the regression line using excel
5. calculate the y intercept,b, of vthe regression line using excel
6. write the regression line using the answer from problems 4 and 5. Y=mx+b
7. Given the regression line y=2.3x-4, predict y for x=10
Get Answers For Free
Most questions answered within 1 hours.