Assume you have noted the following prices for books and the number of pages that each book contains. Price Book Pages ($) A 500 7.00 700 7.50 750 9.00 590 6.50 E 540 7.50 650 7.00 1. Compute and...

Help me please

Extracted text: Assume you have noted the following prices for books and the number of pages that each book contains. Price Book Pages ($) A 500 7.00 700 7.50 750 9.00 590 6.50 E 540 7.50 650 7.00 1. Compute and write down the estimated regression equation. If using Excel, provide a screenshot of your work. If calculating by hand, show all your work. 2. What is value of the correlation coefficient? What can you comment on the strength and direction of the relationship between the two variables? Use a t-test (including all four steps) to determine whether number of pages is related to the price of the book. Use the output of your Excel for Regression. Show your work. Use a F-test (including all four steps) to determine whether number of pages is related to the price 3. of the book. Use the output of your Excel for Regression. Show your work. B. C. D.