Chapter 4 - Part 3

Chapter 4 - Part 3 - A Look at the U.S. Total Retail Sales...

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

View Full Document Right Arrow Icon
3/10/11 A Look at the U.S. Total Retail Sales The data on the next slide consist of the total U.S. retail sales (excluding motor vehicle and parts dealers) in billions of dollars for four years We’ll use the time series
Background image of page 1

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

View Full DocumentRight Arrow Icon
3/10/11 Total U.S. Retail Trade 2004 2005 2006 2007 Jan 220.458 231.134 253.084 264.342 Feb 217.362 227.910 247.107 256.234 Mar 240.615 258.297 280.039 293.112 Apr 242.168 257.794 276.634 284.152 May 251.154 266.893 293.456 309.461 Jun 245.942 265.450 287.487 299.831 Jul 249.349 263.898 282.706 296.300 Aug 250.073 274.253 294.334 306.475 Table 4.7
Background image of page 2
3/10/11 Using the KPK Macros – Excel 2007
Background image of page 3

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

View Full DocumentRight Arrow Icon
3/10/11 The Input Window
Background image of page 4
3/10/11 Moving Averages and Moving Centered Ratio to Total Moving Moving Year Month t (1) Yt (2) (3) Average (4) Average (5) 2004 Jan 1 220.458 Feb 2 217.362 Mar 3 240.615 Apr 4 242.168 May 5 251.154 Jun 6 245.942 Jul 7 249.349 248.926 1.002 Aug 8 250.073 249.810 1.001 Sep 9 240.047 250.987 0.956 Oct 10 251.036 252.375 0.995 Nov 11 258.980 253.681 1.021 Dec 12 314.591 255.150 1.233 2981.775 2992.451 3002.999 3020.681 3036.307 3052.046 3071.554
Background image of page 5

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

View Full DocumentRight Arrow Icon
3/10/11 Moving Averages and Moving Centered Ratio to Total Moving Moving Year Month t (1) Yt (2) (3) Average (4) Average (5) 2007 Jan 37 264.342 290.436 0.910 Feb 38 256.234 291.508 0.879 Mar 39 293.112 292.362 1.003 Apr 40 284.152 293.417 0.968 May 41 309.461 295.048 1.049 Jun 42 299.831 296.462 1.011 Jul 43 296.300 Aug 44 306.475 Sep 45 283.135 Oct 46 297.128 Nov 47 313.157 Dec 48 360.089 3492.025 3504.166 3512.513 3529.483 3551.669 3563.416
Background image of page 6
3/10/11 Summary of Ratios Month Year Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2004 1.002 1.001 0.956 0.995 1.021 1.233
Background image of page 7

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

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

Page1 / 28

Chapter 4 - Part 3 - A Look at the U.S. Total Retail Sales...

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

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