Using the TGT Quarterly Sales (Target Corp.) data: a. Create a line chart of sales. Do you

Question:

Using the TGT Quarterly Sales (Target Corp.) data:

a. Create a line chart of sales. Do you see a trend? Do you see any seasonality? If so, what is the frequency?

b. Using the procedures detailed in the chapter, decompose the time series into the trend, seasonality, and irregular components.

c. Which of the time series methodologies discussed in the chapter would likely be the most appropriate for forecasting Target’s sales?


Data from Target Corp.

Target Corporation Quarterly Revenue and Net Income





Report DateFiscal YearFiscal QuarterRevenueNet Income
4/30/20062006112,863554
7/31/20062006213,347609
10/31/20062006313,570506
1/31/20072006419,7101,119
4/30/20072007114,041651
7/31/20072007214,620686
10/31/20072007314,835483
1/31/20082007419,8711,028
4/30/20082008114,802602
7/31/20082008215,472634
10/31/20082008315,114369
1/31/20092008419,560609
4/30/20092009114,833522
7/31/20092009215,067594
10/31/20092009315,276436
1/31/20102009420,181936
4/30/20102010115,593671
7/31/20102010215,532679
10/31/20102010315,605535
1/31/20112010420,6611,035
4/30/20112011115,935689
7/31/20112011216,240704
10/31/20112011316,402555
1/31/20122011421,288981
4/30/20122012116,867697
7/31/20122012216,779704
10/31/20122012316,929637
1/31/20132012422,726961
4/30/20132013116,706498
7/31/20132013217,117611
10/31/20132013317,258341
1/31/20142013421,515520
4/30/20142014117,050418
7/31/20142014217,406234
10/31/20142014317,732352
1/31/20152014421,751960
4/30/20152015117,119651
7/31/20152015217,427773
10/31/20152015317,613476
1/31/20162015421,6261,421
4/30/20162016116,196614
7/31/20162016216,169625
10/31/20162016316,441608
1/31/20172016420,690821
4/30/20172017116,017677
7/31/20172017216,429671
10/31/20172017316,667478
1/31/20182017422,7661102
4/30/20182018116,781717
7/31/20182018217,776799
10/31/20182018317,821616
1/31/20192018422,977798













Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  answer-question
Question Posted: