2 assignments I need help with

Data

Week	#Flashdrives
1	6
2	7
3	6
4	5
5	7
6	5
7	6
8	6
9	8
10	9
11	9
12	7
13	5
14	6
15	8
16	8
17	9
18	7
19	6
20	8
21	5
22	7
23	6
24	8
25	10
26	9
27	7
28	8
29	7
30	6

Regression Output

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.3030051829
R Square	0.0918121408
Adjusted R Square	0.0593768602
Standard Error	1.33523753
Observations	30
ANOVA
	df	SS	MS	F	Significance F
Regression	1	5.0466073415	5.0466073415	2.8306257539	0.1036030452
Residual	28	49.9200593252	1.7828592616
Total	29	54.9666666667
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	6.2988505747	0.5000101492	12.5974454408	0	5.2746262141	7.3230749354	5.2746262141	7.3230749354
X Variable 1	0.0473859844	0.0281649303	1.6824463599	0.1036030452	-0.0103072599	0.1050792288	-0.0103072599	0.1050792288
RESIDUAL OUTPUT
Observation	Predicted Y	Residuals	Standard Residuals
1	6.3462365591	-0.3462365591	-0.2638969529
2	6.3936225436	0.6063774564	0.4621729244
3	6.441008528	-0.441008528	-0.3361309015
4	6.4883945124	-1.4883945124	-1.1344347274
5	6.5357804968	0.4642195032	0.3538220016
6	6.5831664813	-1.5831664813	-1.206668676
7	6.6305524657	-0.6305524657	-0.4805987986
8	6.6779384501	-0.6779384501	-0.5167157729
9	6.7253244346	1.2746755654	0.9715409561
10	6.772710419	2.227289581	1.6976108334
11	6.8200964034	2.1799035966	1.6614938591
12	6.8674823878	0.1325176122	0.1010031816
13	6.9148683723	-1.9148683723	-1.4594874959
14	6.9622543567	-0.9622543567	-0.7334176186
15	7.0096403411	0.9903596589	0.7548391104
16	7.0570263255	0.9429736745	0.7187221361
17	7.10441231	1.89558769	1.4447920135
18	7.1517982944	-0.1517982944	-0.1156986641
19	7.1991842788	-1.1991842788	-0.91400249
20	7.2465702633	0.7534297367	0.574254239
21	7.2939562477	-2.2939562477	-1.7484232902
22	7.3413422321	-0.3413422321	-0.2601665612
23	7.3887282165	-1.3887282165	-1.0584703871
24	7.436114201	0.563885799	0.4297863418
25	7.4835001854	2.5164998146	1.9180430708
26	7.5308861698	1.4691138302	1.1197392449
27	7.5782721542	-0.5782721542	-0.4407514326
28	7.6256581387	0.3743418613	0.2853184447
29	7.6730441231	-0.6730441231	-0.5129853812
30	7.7204301075	-1.7204301075	-1.3112892071

X Variable 1 Line Fit Plot

Y 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 6 7 6 5 7 5 6 6 8 9 9 7 5 6 8 8 9 7 6 8 5 7 6 8 10 9 7 8 7 6 Predicted Y 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 6.3462365591397845 6.3936225435669263 6.4410085279940672 6.488394512421209 6.5357804968483499 6.5831664812754909 6.6305524657026327 6.6779384501297736 6.7253244345569154 6.7727104189840563 6.8200964034111973 6.8674823878383391 6.91486837226548 6.9622543566926218 7.0096403411197628 7.0570263255469037 7.1044123099740455 7.1517982944011864 7.199184278 8283282 7.2465702632554692 7.2939562476826101 7.3413422321097519 7.3887282165368928 7.4361142009640346 7.4835001853911756 7.5308861698183165 7.5782721542454583 7.6256581386725992 7.673044123099741 7.720430107526882

X Variable 1

Solution

Submit your statistical output from Excel, which should include values for a slope, y-intercept, regression equation, r, and R2.
Output is Regression output.
Slope	0.0473859844
Y intercept	6.2988505747
Regression Equation	6.29885057471264 + 0.047386 X				X is in weeks		Ouput is number of defective flash drives
R	0.0918121408
R square	0.0593768602