2. Create and insert a scatter diagram with trendline in EXCEL for the following: Book Pages (x variable) Price (y variable) A 119 $7.00 B 500 $9.25 C 364 $7.80 D 411 $8.50 E 200 $7.25 F 284 $8.25 G 158 $6.95 H 550 $9.95 Then a. Show the equation of the trendline on the scatter diagram along with the coefficient of correlation (r squared). b. Using Pearson's Product Moment Correlation Coefficient, discuss the strength of the relationship between pages and price. Make sure you have stated the value of r. c. What type of relationship, if any, is there between pages and price? Use words like strong, weak, positive, negative, no relationship.!. d. According to the trendline, how much should a book that is 560 pages cost