# Statistics Analysis

*label*Statistics

*timer*Asked: Apr 26th, 2017

**Question description**

Data set 2 presents a sample of the number of defective flash drives produced by a small manufacturing company over the last 30 weeks. The company’s operations manager believes that the number of defects produced by the process is less than seven defective flash drives per week.

Use Excel’s Analysis ToolPak 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 the

slope, y-intercept, regression equation, r, and R2.

Submit a Word file that includes the hypothesis test. Specifically, the following critical elements must be addressed:

I.

Methodology

II.

Analysis

Guidelines for Submission:

Submit a 1-page Word document with spreadsheet..