Question

I have the correct answer but I want to know how to solve it step by step, please help. Thanks

ID	X	Y
A	2	6
B	5	4
C	8	5
D	6	2
E	9	4

1) What is the obtained F-ratio? (correct answer: 0.474)

2) What can you conclude with ANOVA? (correct answer: Fail to reject the null, p> 0.01; Type II error is possible)

3) What is the standard deviation of Y for the sample? (correct answer: 1.33)

4) What is the standard error of the estimate for the sample? (correct answer: 1.23)

Answer 1

Ans:

a)

Regression equation:

Y'=-0.2x+5.4

ID	X	Y	Y'	(y-y')^2	(Y'-4.2)^2	(Y-4.2)^2
A	2	6	5	1	0.64	3.24
B	5	4	4.4	0.16	0.04	0.04
C	8	5	3.8	1.44	0.16	0.64
D	6	2	4.2	4.84	0	4.84
E	9	4	3.6	0.16	0.36	0.04
Total	30	21	21	7.6	1.2	8.8

Source	SS	df	MS	F
regression	1.2	1	1.200	0.474
error	7.6	3	2.533
total	8.8	4

MS=SS/df

F=1.2/2.533=0.474

2)p-value=FDIST(0.474,1,3)=0.5406

Fail to reject null hypothesis,as p-value>0.01

3)standard deviation for y=1.33

(use stdevp excel function)

4)standard error of estimate=sqrt(7.6/5)=1.23