forecasting lab data

# forecasting lab data - SUMMARY OUTPUT Regression Statistics...

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

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

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

View Full Document
Upper 95.0% 20.12 0.81
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

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

View Full Document
g average (which performs best?). nt month, .3 for second most recent month and .1 for the last month
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 04/07/2008 for the course BUAD 110 taught by Professor Kydd during the Fall '07 term at University of Delaware.

### 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
Ask a homework question - tutors are online