Good evening! I would like to verify the information below to see if it is correct. Thank You.

Data set 2 presents a sample of the number of defective flash drives produced by a small manufacturing company over the last 30 weeks. Use Excel's Analysis ToolPak (or any statistical package that you are comfortable with) to compute the regression equation for predicting the number of defective flash drives over time (in weeks), the correlation coefficient r and the coefficient of determination R2. Submit your statistical output from Excel, which should include values for a slope, y-intercept, regression equation, r, and R2, and a one-page Word document in which you present an analysis of your results.

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

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.303005183
R Square	0.091812141
Adjusted R Square	0.05937686
Standard Error	1.33523753
Observations	30
ANOVA
	df	SS	MS	F	Significance F
Regression	1	5.046607341	5.046607341	2.830625754	0.103603045
Residual	28	49.92005933	1.782859262
Total	29	54.96666667
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	6.298850575	0.500010149	12.59744544	4.69443E-13	5.274626214	7.323074935	5.274626214	7.323074935
Week	0.047385984	0.02816493	1.68244636	0.103603045	-0.01030726	0.105079229	-0.01030726	0.105079229