Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.

QUESTION

Correlation and Regression on Data Set 2

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.

Specifically, the following critical elements must be addressed:

I. Methodology

II. Analysis

Guidelines for Submission: Submit a 1-page Word document with attached spreadsheet.

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question