SPC A sample solution - SUMMARY OUTPUT Regression...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: SUMMARY OUTPUT Regression Statistics Multiple R 0.93 R Square 0.87 Adjusted R 0.86 Standard E 511.08 Observation 16 ANOVA df SS MS F ignificance F Regression 1 ### ### 90.59 Residual 14 ### 261200.76 Total 15 ### CoefficientsStandard Et Stat P-value Lower 95%Upper 95%Lower 95.0Upper 95.0% Intercept 3612.24 317.84 11.36 2930.54 4293.95 2930.54 4293.95 X Variable 263.81 27.72 9.52 204.36 323.26 204.36 323.26 CR - 10/17/2010 07:01:01 e8a1f130dc99c7a6f4e0c935fb1be292cbb5ff22.xls - Static Forecast SPC Note that I only provide a sample forecast for clear plastic. Same applies to black plastic. Year Quarter 2005 I 3200 II 7658 p = 4 (even) III 4420 IV 2384 2006 I 3654 II 8680 III 5695 IV 1953 2007 I 4742 II 13673 III 6640 IV 2737 2008 I 3468 II 13186 III 5448 IV 3485 2009 I 7728 II 16591 III 8236 IV 3316 Quarter period Forecast MAD Desaesonalized Demand Regression I 1 3200 3876 0.83 2950-250 250 II 2 7658 4140 1.85 7864 206 206 III 3 4420 4472 4404 1.00 4176-244 244 IV 4 2384 4657 4667 0.51 1936...
View Full Document

Page1 / 3

SPC A sample solution - SUMMARY OUTPUT Regression...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online