Assume you have noted the following prices for books and the number of pages that each book contains. Copy and paste the numbers in an Excel worksheet and then use Excel's Regression tool to conduct a simple linear regression analysis. Answer the following questions. BookPages (x)Price (y)A500$7.00B7007.50C7509.00D5906.50E5407.50F6507.00G4804.50 If we choose significance level at 10% (i.e. let α = .10), the 90% confidence interval does not include 0. Is this statement correct?YesNoWhat is the upper bound of the 90% confidence interval? (keep 2 decimal places) Use the estimated regression equation to estimate the book price. What is the estimated book price if a book has 800 pages? (Note: keep 4 decimal places during the calculation. When reporting the result (i.e. the estimated book price), keep 2 decimal places)

1 The regression output for the given dataset, as obtained in excel, is as follows:…

Answered: Assume you have noted the following…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

Assume you have noted the following prices for books and the number of pages that each book contains. Copy and paste the numbers in an Excel worksheet and then use Excel's Regression tool to conduct a simple linear regression analysis. Answer the following questions.

Book	Pages (x)	Price (y)
A	500	$7.00
B	700	7.50
C	750	9.00
D	590	6.50
E	540	7.50
F	650	7.00
G	480	4.50

If we choose significance level at 10% (i.e. let α = .10), the 90% confidence interval does not include 0. Is this statement correct?

Yes No
What is the upper bound of the 90% confidence interval? (keep 2 decimal places)
Use the estimated regression equation to estimate the book price. What is the estimated book price if a book has 800 pages? (Note: keep 4 decimal places during the calculation. When reporting the result (i.e. the estimated book price), keep 2 decimal places)

Expert Solution