55 4452605 4532630 4586908 17954097 4488524 4586908

Info iconThis preview shows page 1. Sign up to view the full content.

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

Unformatted text preview: a has a standard deviation of The forecast exceeds the accuracy of a simple average by 3.93% 2,309.47 95.63% Audit Trail - Summary Analysis Audit Trail - Statistics Accuracy Measures Mean Absolute Percentage Error (MAPE) R-Square Root Mean Square Error Method Statistics Method Selected Level Seasonal Trend Decomposition type Seasonal Indexes Index 0 Index 1 Index 2 Index 3 Value 3.93% 95.63% 481.20 Forecast Statistics Mean Standard Deviation Value Holt Winters 0.04 0.03 0.08 Multiplicative Value 0.99 0.99 1.01 1.02 ForecastX Configuration Parameters Item Data range selected Time scale for data Periods to forecast Seasonal Length Replace Outliers Activated Replace Outliers Standard Deviations Replace Outliers Forecasting Technique Replace Missing Values Replace Missing Values (Lower Limit) Replace Missing Values (Upper Limit) Remove Leading Zeroes Remove Trailing Zeroes Use Holdback Evaluation Holdback Evaluation Period Apply Tracking Signal Apply Tracking Signal (Under Forecast Percentage) Apply Tracking Signal (Over Forecast Percentage) Forecast Method Selected Report Details Run Date: 2/24/2014 7:04:27 PM Author: Lucas Messenger Note: Value [Chapter 3.xlsx]C3P11'!$A$1:$B$169 Monthly 12.00 No No Yes No No No Holt Winters Value 10,438.21 2,309.47 Tracking Report Dates Jan-1992 Feb-1992 Mar-1992 Apr-1992 May-1992 Jun-1992 Jul-1992 Aug-1992 Sep-1992 Oct-1992 Nov-1992 Dec-1992 Jan-1993 Feb-1993 Mar-1993 Apr-1993 May-1993 Jun-1993 Jul-1993 Aug-1993 Sep-1993 Oct-1993 Nov-1993 Dec-1993 Jan-1994 Feb-1994 Mar-1994 Apr-1994 May-1994 Jun-1994 Jul-1994 Aug-1994 Sep-1994 Oct-1994 Nov-1994 Dec-1994 Jan-1995 Feb-1995 Mar-1995 Apr-1995 May-1995 Jun-1995 Jul-1995 Aug-1995 Sep-1995 Oct-1995 Nov-1995 Dec-1995 Jan-1996 Feb-1996 Mar-1996 Apr-1996 May-1996 Jun-1996 Jul-1996 Aug-1996 Sep-1996 Oct-1996 Nov-1996 Dec-1996 Jan-1997 Feb-1997 Mar-1997 Apr-1997 May-1997 Jun-1997 Jul-1997 Aug-1997 18,000.00 Sep-1997 Oct-1997 Nov-1997 Dec-1997 Jan-1998 Feb-1998 Mar-1998 Apr-1998 May-1998 Jun-1998 Jul-1998 Aug-1998 Sep-1998 Oct-1998 Nov-1998 16,000.00 Dec-1998 Jan-1999 Feb-1999 Mar-1999 Apr-1999 May-1999 Jun-1999 Jul-1999 Aug-1999 Sep-1999 Oct-1999 Nov-1999 Dec-1999 Jan-2000 Feb-2000 Mar-2000 14,000.00 Apr-2000 May-2000 Jun-2000 Jul-2000 Aug-2000 Sep-2000 Oct-2000 Nov-2000 Dec-2000 Jan-2001 Feb-2001 Mar-2001 Apr-2001 May-2001 Jun-2001 12,000.00 Jul-2001 Aug-2001 Sep-2001 Oct-2001 Nov-2001 Dec-2001 Jan-2002 Feb-2002 Mar-2002 Apr-2002 May-2002 Jun-2002 Jul-2002 Aug-2002 Sep-2002 Oct-2002 10,000.00 Nov-2002 Dec-2002 Jan-2003 Feb-2003 Mar-2003 Apr-2003 May-2003 Jun-2003 Jul-2003 Aug-2003 Sep-2003 Oct-20038,000.00 Nov-2003 Dec-2003 Jan-2004 Feb-2004 Mar-2004 Apr-2004 May-2004 Jun-2004 Jul-2004 Aug-2004 Sep-2004 Oct-2004 Nov-2004 Dec-2004 Jan-2005 Feb-2005 Mar-2005 Apr-20056,000.00 May-2005 Jun-2005 Jul-2005 Aug-2005 Sep-2005 Oct-2005 Nov-2005 Dec-2005 Jan-2006 Feb-2006 Mar-2006 Apr-2006 May-2006 Jun-2006 Jul-20064,000.00 Aug-2006 Sep-2006 Oct-2006 Nov-2006 Dec-2006 Actual Fitted Values 6,910.00 Forecast 6,996.12 6,959.00 7,025.49 7,268.00 7,055.32 7,023.00 7,094.99 7,555.00 7,125.03 7,021.00 7,172.88 7...
View Full Document

This document was uploaded on 04/03/2014.

Ask a homework question - tutors are online