Question 1057898


*[illustration EX3.JPG].
.
.
.
Type the data into EXCEL
Highlight the data, choose Insert Scatterplot.
Then right click on a data point and a Format Trendline dialog box will open.
Tick the last two boxes as shown.
.
.
*[illustration EXC2.JPG].
.
.
The equation will be placed on the graph in addition to the coefficient of determination. The square root of the coefficient of determination is the correlation coefficient. 
.
.
.
When you have the equation, find the values of y when {{{x=3.1}}} and {{{x=1.7}}}.