Question

Q1,

Assume you have noted the following prices for books and the number of pages that each book contains.

	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

Given the Excel Output, fine the estimated equation of the regression line:

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.750271
R Square	0.56290658
Adjusted R Square	0.4754879
Standard Error	0.98061487
Observations	7
ANOVA
	df	SS	MS	F	Significance F
Regression	1	6.19197237	6.19197237	6.43920216	0.05204836
Residual	5	4.80802763	0.96160553
Total	6	11
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	1.04155344	2.37717411	0.43814773	0.67956158	-5.0691671	7.15227403	-5.0691671	7.15227403
Pages (x)	0.00990716	0.00390421	2.53755831	0.05204836	-0.0001289	0.01994324	-0.0001289	0.01994324

	a.	y-hat=0.7503x+0.5629
	b.	y-hat=0.0039x+2.3772
	c.	y-hat=1.0415x+0.0099
	d.	y-hat=0.0099x+1.0415

Q2

Refer to question 1. What percent of the variation in y is explained by the model. Round your answer to 2 decimal places (do not put % sign)

Q3

Refer to question 1. What is the p-value of the t-test (use 3 decimal places)

Q4

Refer to Question 1 Based on p-value can you conclude that there is a linear relationship between x and y variables? Use alpha=0.05

	a.	Yes, there is a strong linear relationship between x and y
	b.	No, there is no linear relationship between x and y
	c.	It can not be determined
	d.	None of the above answers is correct

Answer 1

Estimated equation of Requession line e y = 0:099x + 1.045 - R²= 0.5629 so this gives that variation in y is is officient of percent. the model about 56.29 explained by determination. of This Ho: D/W Thaw is no signpiant reente uclationship X 84 variable Relationship between X & Y is significant. Hi.. d = 0.05 Here t pages = 2.54 dif=5 evalue= 0.51894 Since p valu 70.05 We do not There is no X and y. Reject linear Ho. relationship between