Assume you have noted the following prices for paperback books and the number of pages that each book contains.
Pages (x variable)
Price (y variable)
$6.25Create a scatter diagram using Excel for the data in the above chart. Place the trendline, the equation of the trendline, and the coefficient of determination on the scatter diagram. Hint from Dr. Klotz: The trendline can be added by using the green + sign that appears right after making the graph. Click on the + and go down to trendline. There is a black triangle next to the word “trendline” – use that to get the equation and coefficient of determination on the graph.Define “coefficient of determination” and “Pearson’s product moment correlation coefficient.” Explain the relationship between the coefficient of determination and Pearson’s product moment correlation coefficient. What does each one tell us?Compute the value for Pearson’s product moment correlation coefficient. What does it tell us about the strength of the relationship between the x and y variables?According to the equation for the trendline, if there are 640 pages in the book, how much should it cost?According to the trendline, if the cost of the book were $12.25, how many pages should there be?Why would some hesitate to accept the answer in #5 but not hesitate to accept the answer in #4? Conduct a full hypothesis test to see if x and y are related. Use α = 0.05.