how to to scatter with Regression

[xiaojia1222]

given 100 samples,
to calculate: numbers of hours spent on study is dependent on numbers of hours spent on social networking site.

x (social networking site)	y (study)	x^2		xy
6	4	36	16	24
6	4	36	16	24
6	3	36	9	18
6	3	36	9	18
6	3	36	9	18
6	3	36	9	18
6	3	36	9	18
6	2	36	4	12
6	2	36	4	12
6	2	36	4	12
6	2	36	4	12
6	2	36	4	12
6	2	36	4	12
6	2	36	4	12
6	2	36	4	12
6	2	36	4	12
6	2	36	4	12
6	2	36	4	12
6	2	36	4	12
6	1	36	1	6
6	1	36	1	6
6	1	36	1	6
6	1	36	1	6
6	1	36	1	6
6	1	36	1	6
6	1	36	1	6
6	1	36	1	6
6	1	36	1	6
6	1	36	1	6
6	1	36	1	6
6	1	36	1	6
6	1	36	1	6
6	1	36	1	6
6	1	36	1	6
4	4	16	16	16
4	4	16	16	16
4	4	16	16	16
4	4	16	16	16
4	3	16	9	12
4	3	16	9	12
4	3	16	9	12
4	3	16	9	12
4	3	16	9	12
4	3	16	9	12
4	3	16	9	12
4	2	16	4	8
4	2	16	4	8
4	2	16	4	8
4	2	16	4	8
4	2	16	4	8
4	2	16	4	8
4	2	16	4	8
4	2	16	4	8
4	2	16	4	8
4	2	16	4	8
4	2	16	4	8
4	2	16	4	8
4	2	16	4	8
4	2	16	4	8
4	1	16	1	4
4	1	16	1	4
2	1	4	1	2
2	2	4	4	4
2	2	4	4	4
2	2	4	4	4
2	2	4	4	4
2	2	4	4	4
2	2	4	4	4
2	2	4	4	4
2	2	4	4	4
2	3	4	9	6
2	3	4	9	6
2	3	4	9	6
2	3	4	9	6
2	3	4	9	6
2	3	4	9	6
2	3	4	9	6
2	3	4	9	6
2	3	4	9	6
2	3	4	9	6
2	4	4	16	8
2	4	4	16	8
2	4	4	16	8
2	4	4	16	8
2	4	4	16	8
2	4	4	16	8
2	4	4	16	8
2	4	4	16	8
2	4	4	16	8
2	4	4	16	8
1	3	1	9	3
1	3	1	9	3
1	3	1	9	3
1	4	1	16	4
1	4	1	16	4
1	4	1	16	4
1	4	1	16	4
1	4	1	16	4
1	4	1	16	4
total: 379	total: 249	total: 1781	total: 731	total: 847

<tbody>
</tbody>

SUMMARY OUTPUT								SUMMARY OUTPUT
Regression Statistics								Regression Statistics
Multiple R	0.571423290877713							Multiple R
R Square	0.326524577357515							R Square
Adjusted R Square	0.319581531763263							Adjusted R Square
Standard Error	1.51385801853831							Standard Error
Observations	99							Observations
ANOVA								ANOVA
	df	SS	MS	F	Significance F
Regression	1	107.779496352413	107.779496352413	47.0290124016784	0.000000000653814			Regression
Residual	97	222.301311728395	2.29176610029273					Residual
Total	98	330.080808080808						Total
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%
Intercept	6.3798225308642	0.401972497115064	15.8712911372093	0	5.58201839569999	7.1776266660284	5.58201839569999	Intercept
X Variable 1	-1.01446759259259	0.147929656422649	-6.85777022082822	0.000000000653814	-1.30806701159371	-0.720868173591479	-1.30806701159371	X Variable 1

<tbody>
</tbody>

So, i've got the coefficient of correlation equals to

0.57, how can i plot my scatter graph?


please help me, thank you. ​

 

[marious]

Mr. Girvin has an excellent video that shows you how to scatter the graph, calculate the regression line, slope = m , intercept, coefficient of determination = R^2
https://www.youtube.com/watch?v=ECA2VSOhbuU