Module 5, Problem 40 - monthly U.S. retail sales data....

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: 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 Feb-93 144,335 Mar-93 163,943 Apr-93 169,634 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...
View Full Document

Ask a homework question - tutors are online