1. Given the following

Book	Pages (x variable)	Price (y variable)
A	272	$9.25
B	307	$10.55
C	256	$8.95
D	399	$13.00
E	374	$12.85
F	333	$9.70
G	357	$10.40

Explain the process of how to generate 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 412 pages, how much should it cost?

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

e. In part c, 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, how confident should you be in the answer to part d?

g. When considering interpolation, extrapolation, and r values - how should we put these things 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.