4-1 Data Set Homework: Correlation and Regression on Data Set 2 Data set 2 prese

Question

4-1 Data Set Homework: 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.

Explain in detal what these calculation mean and represent?

Explanation / Answer

Interpret regression equation: At the begining, the flashdrive produced is 6.2989. For each increase in week, the Flashdrives produced are supposed to increase with a value of 0.0474.

R^2=0.0918, This signifies that around 9.18% variation is flashdrives produced accounts for variation in time of manufacturing week.

Correlation coefficient, r=0.303, the positive sign indicates that there exists a positive linear relationship among the variables-flashdrives produced and week. But the value is low to indicate a very weak positive linear relationsip among th evariables concerned.

Related Questions

Navigate

• Browse (All)
• Browse 4
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.