Question

(4)(a)Draw a scatter diagram for the data set in table 3.What does the diagram show about the nature of the relationship between both variables? (b)Use an appropriate statistical measure to determine the degree of association between both variables. Interpret your result.

Thank you for your time , also would appreciate if you could be online at 9am eastern time tomorrow 1/17/18

Answer 1

ANSWER:

A) THE SCATTER PLOT SHOWS A POSITIVE RELATIONSHIP BETWEEN X AND Y AS X INCREASES Y ALSO INCREASES.

FOR DRAWING SCATTER PLOT GO TO THE INSERT FUNCTION IN EXCEL AND THEN CHARTS AND SELECT THE TABLE OF Y AND X

B) THE STATISTICAL MEASURE USED IS SIMPLE REGRESSION AND IT SHOWS THEY ARE RELATED

THE ADJUSTED R SQUARE VALUE OF 0.87 SHOWS THAT THE VALUE OF Y IS HIGHLY DEPENDENT ON X AND X INCREASES Y ALSO INCREASES.

SIMPLE REGRESSION OUTPUT AS RUN IN EXCEL

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.878585
R Square	0.771912
Adjusted R Square	0.743401
Standard Error	6.854642
Observations	10
ANOVA
	df	SS	MS	F	Significance F
Regression	1	1272.111111	1272.111	27.07419	0.000819109
Residual	8	375.8888889	46.98611
Total	9	1648
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	14.27778	6.109652604	2.336921	0.047644	0.188893609	28.36666	0.188894	28.36666
X Variable 1	5.944444	1.142440262	5.203287	0.000819	3.309972475	8.578916	3.309972	8.578916