Module 5 DQ 1 - Data Needed Month Houses Sold Jan-94 128...

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

View Full Document Right Arrow Icon
Data Needed Month Houses Sold INTERPRETATION: Jan-94 128 Feb-94 135 Mar-94 130 Apr-94 127 May-94 125 Jun-94 119 Jul-94 108 Aug-94 112 Sep-94 111 Oct-94 141 Nov-94 126 Dec-94 113 Jan-95 107 Feb-95 110 Mar-95 122 Apr-95 128 May-95 121 Jun-95 131 Jul-95 134 Aug-95 138 Sep-95 132 Oct-95 131 Nov-95 130 Dec-95 125 Jan-96 146 Feb-96 137 Mar-96 132 Apr-96 128 May-96 141 Jun-96 122 Jul-96 133 Aug-96 173 Sep-96 130 Oct-96 117 Nov-96 127 Dec-96 148 Jan-97 148 Feb-97 119 Mar-97 125 Apr-97 134 May-97 137 Jun-97 157 Jul-97 152 Aug-97 138 Sep-97 129 Oct-97 133 Nov-97 166 Dec-97 157 Jan-98 166 Feb-98 187 Mar-98 178 Apr-98 151 May-98 147 Jun-98 173 Jul-98 160 Aug-98 149 Sep-98 175 Oct-98 159 Nov-98 161 Dec-98 186 Jan-99 152 Feb-99 163 Mar-99 149 Apr-99 169 May-99 175 Jun-99 171 Jul-99 171 Aug-99 185 Sep-99 158 Oct-99 189 Nov-99 178 Dec-99 148 Jan-00 146 Feb-00 166 Mar-00 168 Apr-00 139 May-00 150 Jun-00 148 Jul-00 169 Aug-00 141 Sep-00 163 Oct-00 158 Nov-00 149 Dec-00 174 Jan-01 173 Feb-01 168 Mar-01 192 Apr-01 176 May-01 186 Highlighted by the color of the word it will coordinate with the appropriate tab. the Summary of the results are: The optimal smoothing constants are alpha = .251 , beta = 0.00 , MAE = 11.2, RMSE = 13.9, MAPE = 7.7%. The various types of forecasting yielded similar results with the exception of hotlz, as there is an upward trend in housing sales over this period.
Background image of page 1

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

View Full DocumentRight Arrow Icon
StatTools Report Analysis: Time Series Graph Performed By: Andrew James Date: Sunday, September 04, 2011 Updating: Live 1 4 7 10 13 16 19 22 25 28 31 34 37 40 43 46 49 52 55 58 61 64 67 70 73 76 79 82 85 88 0 50 100 150 200 250 Time Series of Houses Sold / Data Set #1 Observation #
Background image of page 2
StatTools Report Analysis: Forecast Performed By: Andrew James Date: Sunday, September 04, 2011 Updating: Live/Unlinked Forecasting Constant Span 3 Moving Averages Mean Abs Err #NAME? Root Mean Sq Err #NAME? Mean Abs Per% Err #NAME? Forecasting Data Houses Sold Forecast Error Jan-2002 128.00 Feb-2002 135.00 Mar-2002 130.00 Apr-2002 127.00 #NAME? #NAME? May-2002 125.00 #NAME? #NAME? Jun-2002 119.00 #NAME? #NAME? Jul-2002 108.00 #NAME? #NAME? Aug-2002 112.00 #NAME? #NAME? Sep-2002 111.00 #NAME? #NAME? Oct-2002 141.00 #NAME? #NAME? Nov-2002 126.00 #NAME? #NAME? Dec-2002 113.00 #NAME? #NAME? Jan-2003 107.00 #NAME? #NAME? Feb-2003 110.00 #NAME? #NAME? Mar-2003 122.00 #NAME? #NAME? Apr-2003 128.00 #NAME? #NAME? May-2003 121.00 #NAME? #NAME? Jun-2003 131.00 #NAME? #NAME? Jul-2003 134.00 #NAME? #NAME? Aug-2003 138.00 #NAME? #NAME? Sep-2003 132.00 #NAME? #NAME? Oct-2003 131.00 #NAME? #NAME? Nov-2003 130.00 #NAME? #NAME? Dec-2003 125.00 #NAME? #NAME? Jan-2004 146.00 #NAME? #NAME? Feb-2004 137.00 #NAME? #NAME? Mar-2004 132.00 #NAME? #NAME?
Background image of page 3

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

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

Page1 / 8

Module 5 DQ 1 - Data Needed Month Houses Sold Jan-94 128...

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

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