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...

I attached all the files below


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 Year 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