Final Assignment – Business Forecasting Techniques Complete two case studies in the textbook using SPSS. Question 7-2 (THE DATA FOR THIS QUESTIONS IS ATTACHED IN SEPERATED EXCEL FILE) QUESTION 9-1...

Final Assignment – Business Forecasting Techniques
Complete two case studies in the textbook using SPSS.
Question 7-2 (THE DATA FOR THIS QUESTIONS IS ATTACHED IN SEPERATED EXCEL FILE)
QUESTION 9-1 (THE DATA FOR THIS QUESTIONS IS ATTACHED IN SEPERATED EXCEL FILE)
· Define the original data as monthly data instead of weekly data. Suppose the data starts January 2010. Click Data Menu in SPSS, then click define date and time.
QUESTIONS:

Sheet: Sheet1
Yea
Mon
Calls
Rate
Temp
1987.0
35582.0
6.994
35612.0
6.8137
35643.0
6.3648
35674.0
6.5435
35704.0
6.7826
35735.0
6.9225
35765.0
7.156
1988.0
35431.0
7.9143
35462.0
7.7576
35490.0
7.0641
35521.0
6.0977
35551.0
20002.0
5.7867
55.1
35582.0
21591.0
5.7592
59.0
35612.0
22696.0
5.5718
63.8
35643.0
21509.0
5.2939
63.8
35674.0
22123.0
5.4709
59.1
35704.0
21449.0
5.5049
54.6
35735.0
23475.0
5.863
45.4
35765.0
23529.0
6.1349
41.0
1989.0
35431.0
23327.0
7.5474
40.3
35462.0
24050.0
7.8157
34.3
35490.0
24010.0
7.139
43.2
35521.0
19735.0
6.2637
52.5
35551.0
20153.0
5.8332
55.3
35582.0
19512.0
5.8077
62.4
35612.0
19892.0
5.6713
62.9
35643.0
20326.0
5.4977
63.5
35674.0
19378.0
5.2989
60.9
35704.0
21263.0
5.6028
51.9
35735.0
21443.0
5.9143
46.2
35765.0
23366.0
5.0
41.8
1990.0
35431.0
23836.0
6.1917
41.8
35462.0
23336.0
6.3775
38.9
35490.0
22003.0
5.7234
46.3
35521.0
20155.0
4.7792
51.7
35551.0
20070.0
4.5715
54.9
35582.0
19588.0
4.3899
59.8
35612.0
20804.0
4.2559
66.7
35643.0
19644.0
3.9359
66.4
35674.0
17424.0
3.9048
61.9
35704.0
20833.0
4.4294
50.4
35735.0
22490.0
5.1523
45.8
35765.0
24861.0
5.5102
33.9
1991.0
35431.0
23441.0
6.8901
37.9
35462.0
19205.0
7.0308
46.9
35490.0
20386.0
6.7186
43.4
35521.0
19988.0
6.128
49.1
35551.0
19077.0
5.8146
54.3
35582.0
19141.0
5.948
58.2
35612.0
20883.0
5.9026
65.4
35643.0
20709.0
5.7227
66.0
35674.0
19647.0
5.6877
60.9
35704.0
22013.0
6.2922
51.0
35735.0
22375.0
7.0615
46.2
35765.0
22727.0
7.437
42.4
1992.0
35431.0
22367.0
8.4513
43.0
35462.0
21155.0
8.7699
46.0
35490.0
21209.0
8.0728
48.9
35521.0
19286.0
7.2392
52.7
35551.0
19725.0
7.0461
58.3
35582.0
20276.0
7.0478
63.6
35612.0
20795.0
7.108
64.9
35643.0
21126.0
6.7824
65.0
35674.0
20251.0
6.7691
58.4
35704.0
22069.0
7.5896
53.2
35735.0
23268.0
7.9908
44.8
35765.0
26039.0
8.246
37.8
1993.0
35431.0
26127.0
9.5301
34.9

Sheet: Sheet1
Sales
1688.0
2514.0
5843.0
4912.0
5133.0
4563.0
5416.0
6416.0
5879.0
3460.0
4517.0
5188.0
5944.0
5842.0
6589.0
5447.0
7548.0
6403.0
4103.0
6594.0
5742.0
3714.0
3399.0
3376.0
3627.0
4201.0
3515.0
3645.0
3416.0
3565.0
2428.0
3292.0
3460.0
6212.0
6057.0
5739.0
5560.0
5335.0
5305.0
5364.0
5511.0
5698.0
5382.0
5629.0
5617.0
5742.0
3747.0
4159.0
4853.0
5607.0
3946.0
1919.0
1898.0
1870.0
3962.0
5973.0
5009.0
5328.0
5014.0
4986.0
5213.0
4807.0
3964.0
5201.0
4863.0
5019.0
4868.0
5777.0
6543.0
6352.0
5837.0
7162.0
4997.0
4063.0
3942.0
4011.0
3999.0
4794.0
4956.0
3885.0
4209.0
3614.0
3722.0
4307.0
3322.0
5962.0
6784.0
6069.0
5897.0
5916.0
4998.0
5111.0
5612.0
5906.0
6010.0
5937.0
6004.0
5959.0
4223.0
4679.0
5307.0
6101.0
6896.0
2214.0