Price Book Pages ($) A. 500 7.00 700 7.50 C 750 9.00 590 6.50 540 7.50 650 7.00 Compute and write down the estimated regression equation. If using Excel, provide a screensho your work. If calculating by hand, show all your work. 10 2. What is value of the correlation coefficient? What can you comment on the strength and directi B.

College Algebra
1st Edition
ISBN:9781938168383
Author:Jay Abramson
Publisher:Jay Abramson
Chapter4: Linear Functions
Section: Chapter Questions
Problem 30PT: For the following exercises, use Table 4 which shows the percent of unemployed persons 25 years or...
icon
Related questions
Question

Help me please

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.
Transcribed Image 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.
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Recommended textbooks for you
College Algebra
College Algebra
Algebra
ISBN:
9781938168383
Author:
Jay Abramson
Publisher:
OpenStax
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Algebra and Trigonometry (MindTap Course List)
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:
9781305071742
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning
Functions and Change: A Modeling Approach to Coll…
Functions and Change: A Modeling Approach to Coll…
Algebra
ISBN:
9781337111348
Author:
Bruce Crauder, Benny Evans, Alan Noell
Publisher:
Cengage Learning