1. Given the following

Book	Pages (x variable)	Price (y variable)
A	211	$8.05
B	310	$10.17
C	247	$8.64
D	389	$11.00
E	333	$10.75
F	330	$9.15
G	377	$9.75

do a scatter diagram which shows the trendline (this is the regression line) and provides the coefficient of determination on the graph itself. Include your Excel sheet in your submission. (Upload it)

b. What is the equation of the trendline from the graph? (Just copy it from your graph)

c. According to the equation of the trendline from your graph, if a book had 199 pages, how much should it cost?

d. According to the equation of the trendline from your graph, if a book costs $9.55, how many pages should it have?

e. In part c and d, were you interpolating or extrapolating? How do you know? How confident are you that the number of pages would really be what you calculated it to be? Why?

f. Given the r value of the trendline, describe the strength of the relationship between pages and price. Should we be using this trendline to interpolate? Extrapolate?

g. When considering interpolation, extrapolation, and r values - how should we put these concepts together to come up with an idea of how confident we are to use a trendline in a business situation?

2. The axes labels and title have intentionally been removed from this scatter diagram which shows the trendline.

Review the following scatter diagram.