Question

Show all working.

Use the following data to:
a) draw a scatter plot
b) find the coefficient of correlation and test the significance at the 0.05 level
c) find the regression line
d) predict y' for x = 5

Number of alcoholic drinks - x            Score on a Dexterity Test - y
              2                                                    15
                1                                                    18
                3                                                   11
                4                                                     7
                2                                                    10
                1                                                    16
                5                                                    4
                6                                                     2

Answer 1

a)Scattered plot

b)solvrd in excel

	X=number of alcohol drinks
	Y=score on a dexterity test
	H0: Y is correleted with X
	SUMMARY OUTPUT
	Regression Statistics
	Multiple R	0.961025641	,=absulute value of r
	R Square	0.923570283
	Adjusted R Square	0.910831997
	Standard Error	1.726026265
	Observations	8
	ANOVA
		df	SS	MS	F	Significance F
	Regression	1	216	216	72.5034965	0.000143713	,=p value
	Residual	6	17.875	2.979167
	Total	7	233.875
		Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
	Intercept	19.375	1.220484876	15.87484	3.96475E-06	16.3885811	22.36142	16.38858	22.36142
	X	-3	0.352323636	-8.5149	0.000143713	-3.862104879	-2.1379	-3.8621	-2.1379
		sign of r
	CONCLUSON:there is significant relationship between X and Y

correlation coefficient:-0.9610

C)

regresion equation:Y=19.375-3X

D)put X=5 then Y=4.375

4.375

4.375