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

Info icon This 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.
Image of page 1

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

View Full Document Right 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 #
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? Apr-2004 128.00 #NAME? #NAME? May-2004 141.00 #NAME? #NAME? Jun-2004 122.00 #NAME? #NAME? Jul-2004 133.00 #NAME? #NAME? Aug-2004 173.00 #NAME? #NAME? Sep-2004 130.00 #NAME? #NAME? Oct-2004 117.00 #NAME? #NAME? Nov-2004 127.00 #NAME? #NAME? Dec-2004 148.00 #NAME? #NAME? Jan-2005 148.00 #NAME? #NAME? Feb-2005 119.00 #NAME? #NAME? Mar-2005 125.00 #NAME? #NAME? Apr-2005 134.00 #NAME? #NAME? May-2005 137.00 #NAME? #NAME? Jun-2005 157.00 #NAME? #NAME? Jul-2005 152.00 #NAME? #NAME? Aug-2005 138.00 #NAME? #NAME? Sep-2005 129.00 #NAME? #NAME? Oct-2005 133.00 #NAME? #NAME? Nov-2005 166.00 #NAME? #NAME? Dec-2005 157.00 #NAME? #NAME? Jan-2006 166.00 #NAME? #NAME? Feb-2006 187.00 #NAME? #NAME? Mar-2006 178.00 #NAME? #NAME? Apr-2006 151.00 #NAME? #NAME? May-2006 147.00 #NAME? #NAME? Jun-2006 173.00 #NAME? #NAME? Jul-2006 160.00 #NAME? #NAME? Aug-2006 149.00 #NAME? #NAME? Sep-2006 175.00 #NAME? #NAME? Oct-2006 159.00 #NAME? #NAME? Nov-2006 161.00 #NAME? #NAME? Dec-2006 186.00 #NAME? #NAME? Jan-2007 152.00 #NAME? #NAME? Feb-2007 163.00 #NAME? #NAME? Mar-2007 149.00 #NAME? #NAME? Apr-2007 169.00 #NAME? #NAME? May-2007 175.00 #NAME? #NAME?
Image of page 3

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

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

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern