Module 5 HW - monthly U.S retail sales data While retaining the final 6 months of observations for validation purposes use the method of moving

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

View Full Document Right Arrow Icon

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

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

Unformatted text preview: monthly U.S. retail sales data. While retaining the final 6 months of observations for validation purposes, use the method of moving averages with a careful y chosen span to forecast U.S. retail sales in the next year. P02_37.xlsx, U.S. Retail Sales (in millions of dollars) Month Year Total Jan-93 147,772 Please see tab "Moving Averages Forecast" Feb-93 144,335 Mar-93 163,943 Retainment of final 6 months Apr-93 169,634 Forecast for the next year May-93 175,371 Jun-93 174,825 Jul-93 176,995 Aug-93 176,208 Sep-93 170,202 Oct-93 175,510 Nov-93 180,364 Dec-93 217,629 Jan-94 154,400 Feb-94 155,596 Mar-94 183,782 Apr-94 181,209 May-94 186,395 Jun-94 189,244 Jul-94 184,978 Aug-94 192,925 Sep-94 184,957 Oct-94 188,454 Nov-94 193,411 Dec-94 231,974 Jan-95 166,188 Feb-95 162,959 Mar-95 190,844 Apr-95 186,287 May-95 199,980 Jun-95 201,079 Jul-95 193,423 Aug-95 202,572 Sep-95 191,213 Oct-95 192,351 Nov-95 200,800 Dec-95 236,342 Jan-96 173,264 Feb-96 180,251 Mar-96 199,413 Apr-96 198,610 May-96 213,754 Jun-96 204,705 Jul-96 204,817 Aug-96 212,247 Sep-96 195,749 Oct-96 207,531 Nov-96 210,236 Dec-96 244,719 Jan-97 191,130 Feb-97 188,463 Mar-97 215,391 Apr-97 210,088 May-97 224,372 Jun-97 217,421 Jul-97 221,551 Aug-97 225,563 Sep-97 212,529 Oct-97 221,614 Nov-97 219,590 Dec-97 262,850 Jan-98 198,262 Feb-98 194,928 Mar-98 220,258 Apr-98 224,912 May-98 236,260 Jun-98 234,703 Jul-98 232,508 Aug-98 231,665 Sep-98 222,124 Oct-98 235,049 Nov-98 233,002 Dec-98 281,922 Jan-99 209,566 Feb-99 212,599 Mar-99 244,511 Apr-99 242,761 May-99 254,557 Jun-99 252,350 Jul-99 254,576 Aug-99 256,859 Sep-99 245,799 Oct-99 250,793 Nov-99 257,707 Dec-99 312,851 Jan-00 229,871 Feb-00 244,951 Mar-00 273,112 Apr-00 260,159 May-00 279,257 Jun-00 276,261 Jul-00 267,893 Aug-00 279,472 Sep-00 264,793 Oct-00 266,159 Nov-00 272,790 Dec-00 317,333 Jan-01 244,944 Feb-01 243,611 Mar-01 276,672 Apr-01 268,212 May-01 277,232 Jun-01 268,707 Jul-01 259,802 Aug-01 275,218 Sep-01 244,076 Oct-01 274,035 Nov-01 269,878 Dec-01 306,352 Jan-02 238,044 Feb-02 235,287 Mar-02 264,854 Apr-02 265,434 May-02 280,300 Jun-02 268,892 Jul-02 275,708 Aug-02 287,130 Sep-02 255,223 Oct-02 269,360 Nov-02 272,365 Dec-02 317,525 Jan-03 251,125 Feb-03 241,996 Mar-03 274,312 Apr-03 276,733 May-03 293,013 Jun-03 283,014 Jul-03 291,792 Aug-03 297,743 Sep-03 277,707 Oct-03 286,913 Nov-03 284,444 Dec-03 340,752 Jan-04 265,064 Feb-04 266,449 Mar-04 303,203 Apr-04 299,956 May-04 312,620 Jun-04 306,413 Jul-04 311,933 40. Consider the file P02_37.xlsx, which contains total * Al requirements for the forecast have been meet including: StatTools Report Analysis: Forecast Performed By: Andrew James Date: Wednesday, September 07, 2011 Updating: Live/Unlinked Forecasting Constant Span 7 Moving Averages Mean Abs Er #NAME?...
View Full Document

This note was uploaded on 02/01/2012 for the course BUSINES BUS-660 taught by Professor Paulshriver during the Spring '11 term at Grand Canyon.

Page1 / 9

Module 5 HW - monthly U.S retail sales data While retaining the final 6 months of observations for validation purposes use the method of moving

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

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