forecasting lab data

forecasting lab data - SUMMARY OUTPUT Regression Statistics...

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

View Full Document Right Arrow Icon
SUMMARY OUTPUT Regression Statistics Multiple R 0.58 R Square 0.33 Adjusted R Square 0.26 Standard Error 1.94 Observations 11 ANOVA df SS MS F Significance F Regression 1 16.81 16.81 4.48 0.06 Residual 9 33.74 3.75 Total 10 50.55 CoefficientsStandard Erro t Stat P-value Lower 95% Upper 95%Lower 95.0% Intercept 17.29 1.25 13.81 0 14.46 20.12 14.46 X Variable 1 0.39 0.18 2.12 0.06 -0.03 0.81 -0.03
Background image of page 1

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

View Full DocumentRight Arrow Icon
Upper 95.0% 20.12 0.81
Background image of page 2
National Office Supply sells shredders. Monthly sales for a eleven-month period were as follows: a) Plot monthly data on a graph in Excel. Month Sales (000) b) Forecast sales for July-January (use template on Sheet 2 Feb 19 1 Mar 18 2 1) A five-month moving average vs. a 3-month moving Apr 15 3 2) A Weighted Moving Average using .6 for most recen May 20 4 3) A linear trend equation June 18 5 4) Which model performs best overall? July 22 6 Aug 20 7 Sept 23 8 Oct 19 9 Nov 20 10 Dec 22 11
Background image of page 3

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

View Full DocumentRight Arrow Icon
g average (which performs best?). nt month, .3 for second most recent month and .1 for the last month
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 8

forecasting lab data - SUMMARY OUTPUT Regression Statistics...

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

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