Module 4
lhutchins
DataSet2.xlsxSheet1
| Week | #Flash drives | Number of Defective Flash drives for 30 Weeks | |||||||||
| 1 | 6 | ||||||||||
| 2 | 7 | SUMMARY OUTPUT | |||||||||
| 3 | 6 | ||||||||||
| 4 | 5 | Regression Statistics | |||||||||
| 5 | 7 | Multiple R | 0.3030051829 | ||||||||
| 6 | 5 | R Square | 0.0918121408 | ||||||||
| 7 | 6 | Adjusted R Square | 0.0593768602 | ||||||||
| 8 | 6 | Standard Error | 1.33523753 | ||||||||
| 9 | 8 | Observations | 30 | ||||||||
| 10 | 9 | ||||||||||
| 11 | 9 | ANOVA | |||||||||
| 12 | 7 | df | SS | MS | F | Significance F | |||||
| 13 | 5 | Regression | 1 | 5.0466073415 | 5.0466073415 | 2.8306257539 | 0.1036030452 | ||||
| 14 | 6 | Residual | 28 | 49.9200593252 | 1.7828592616 | ||||||
| 15 | 8 | Total | 29 | 54.9666666667 | |||||||
| 16 | 8 | ||||||||||
| 17 | 9 | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | ||
| 18 | 7 | Intercept | 6.2988505747 | 0.5000101492 | 12.5974454408 | 0 | 5.2746262141 | 7.3230749354 | 5.2746262141 | 7.3230749354 | |
| 19 | 6 | X Variable 1 | 0.0473859844 | 0.0281649303 | 1.6824463599 | 0.1036030452 | -0.0103072599 | 0.1050792288 | -0.0103072599 | 0.1050792288 | |
| 20 | 8 | ||||||||||
| 21 | 5 | ||||||||||
| 22 | 7 | ||||||||||
| 23 | 6 | Slope: 0.0474 | |||||||||
| 24 | 8 | Intercept: 6.2989 | |||||||||
| 25 | 10 | R Square: 0.918 | |||||||||
| 26 | 9 | Correlation coefficient: 0.303 | |||||||||
| 27 | 7 | ||||||||||
| 28 | 8 | ||||||||||
| 29 | 7 | ||||||||||
| 30 | 6 | ||||||||||
