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 The coefficient of determination suggests that 75% of the variability in the book price can be explained by book pages.YesNoPerform an F test and choose the level of significance at 1% (i.e. let α = .01). The p-value associated with the F test at 1% significance level indicates that the price and the number of pages of the books are significantly related. Is this statement correct?YesNoPerform a t test for the independent variable Pages (x). Choose the level of significance at 1% (i.e. let α = .01). The t test result indicates that the independent variable book pages (x) is statistically significant at 0.01 level. Is this statement correct?YesNo

1. The correlation coefficient between the two variables can be obtained in excel using the cell function "CORREL()" which will give r = 0.75 Now the coefficient of determination is calculated as R2=r2=0.752=0.5625 The coefficient of determination is only 56.25% which means the given statement is incorrect. So the correct response is No.2. To test the relation between the two variables it is appropriate to carry out an F-test and determine if the relationship between the two variables is statistically significant or not. If the p-value corresponding to the f-value is less than the significance level then we would have sufficient evidence to conclude that there exists a significant relationship between the two variables. Hence the correct response is given by Yes.3. A t-test cannot be used to test if the explanatory variable is significant or not which means the given statement is incorrect. So the correct response is No.

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

The coefficient of determination suggests that 75% of the variability in the book price can be explained by book pages.

Yes No
Perform an F test and choose the level of significance at 1% (i.e. let α = .01). The p-value associated with the F test at 1% significance level indicates that the price and the number of pages of the books are significantly related. Is this statement correct?

Yes No
Perform a t test for the independent variable Pages (x). Choose the level of significance at 1% (i.e. let α = .01). The t test result indicates that the independent variable book pages (x) is statistically significant at 0.01 level. Is this statement correct?

Yes No