Given the following time series dataset for X over a 48-month period. The dataset consists of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Given the following time series dataset for X over a 48-month period. The dataset consists of monthly observations. We are interested in deasonalising the data using 12 monthly seasonal indexes. Month Jan, 2013 Feb, 2013 Mar, 2013 Apr, 2013 May, 2013 Jun, 2013 Jul, 2013 Aug, 2013 Sep, 2013 Oct, 2013 Nov, 2013 Dec, 2013 Data X 81 102 42 40 53 61 78 58 41 19 18 38 Month Data X 103 120 53 46 Jan, 2014 Feb, 2014 Mar, 2014 Apr, 2014 May, 2014 Jun, 2014 Jul, 2014 Aug, 2014 Sep, 2014 Oct, 2014 Nov, 2014 104 96 81 70 50 35 54 Dec, 2014 57 Month Jan, 2015 Feb, 2015 Mar, 2015 Apr, 2015 May, 2015 Jun, 2015 Jul, 2015 Aug, 2015 Sep, 2015 Oct, 2015 Nov, 2015 Dec, 2015 Data X 122 115 88 63 154 141 107 100 78 61 92 70 Month Jan, 2016 Feb, 2016 Mar, 2016 Apr, 2016 May, 2016 Jun, 2016 Jul, 2016 Aug, 2016 Sep, 2016 Oct, 2016 Nov, 2016 Dec, 2016 Data X 170 196 125 111 110 131 150 124 103 102 102 101 (a) Calculate the 12 un-normalised monthly seasonal indexes for this dataset. (b) Calculate the 12 normalised monthly seasonal indexes for this dataset. (c) Fit a linear trend line to the deseasonalised data using the least squares method. Assuming t = 1 for Jan, 2013, t = 2 for Feb, 2013, etc. (d) Provide 2 unadjusted forecasts for the months of Jan, 2017 and Feb, 2017. Given the following time series dataset for X over a 48-month period. The dataset consists of monthly observations. We are interested in deasonalising the data using 12 monthly seasonal indexes. Month Jan, 2013 Feb, 2013 Mar, 2013 Apr, 2013 May, 2013 Jun, 2013 Jul, 2013 Aug, 2013 Sep, 2013 Oct, 2013 Nov, 2013 Dec, 2013 Data X 81 102 42 40 53 61 78 58 41 19 18 38 Month Data X 103 120 53 46 Jan, 2014 Feb, 2014 Mar, 2014 Apr, 2014 May, 2014 Jun, 2014 Jul, 2014 Aug, 2014 Sep, 2014 Oct, 2014 Nov, 2014 104 96 81 70 50 35 54 Dec, 2014 57 Month Jan, 2015 Feb, 2015 Mar, 2015 Apr, 2015 May, 2015 Jun, 2015 Jul, 2015 Aug, 2015 Sep, 2015 Oct, 2015 Nov, 2015 Dec, 2015 Data X 122 115 88 63 154 141 107 100 78 61 92 70 Month Jan, 2016 Feb, 2016 Mar, 2016 Apr, 2016 May, 2016 Jun, 2016 Jul, 2016 Aug, 2016 Sep, 2016 Oct, 2016 Nov, 2016 Dec, 2016 Data X 170 196 125 111 110 131 150 124 103 102 102 101 (a) Calculate the 12 un-normalised monthly seasonal indexes for this dataset. (b) Calculate the 12 normalised monthly seasonal indexes for this dataset. (c) Fit a linear trend line to the deseasonalised data using the least squares method. Assuming t = 1 for Jan, 2013, t = 2 for Feb, 2013, etc. (d) Provide 2 unadjusted forecasts for the months of Jan, 2017 and Feb, 2017.
Expert Answer:
Answer rating: 100% (QA)
To solve this problem we will follow the steps you provided a Calculate the 12 unnormalised ... View the full answer
Related Book For
Statistics Unlocking The Power Of Data
ISBN: 9780470601877
1st Edition
Authors: Robin H. Lock, Patti Frazer Lock, Kari Lock Morgan, Eric F. Lock, Dennis F. Lock
Posted Date:
Students also viewed these mathematics questions
-
We are interested in investigating whether males and females have equal levels of education. Use the variable EDUC with the Frequencies procedure to produce frequency tables and the mean, the median,...
-
For problems I through 3, use the following time series data: PERIOD DEMAND 10 ......... 248 11 ......... 370 12 ......... 424 13 ......... 286 14 ......... 444 (*) Develop a three - period moving...
-
Using simple moving averages and the following time series data, respond to each of the items. a. G raph the time series data. What do you observe? b. Compute all possible forecasts using a...
-
Use the information in Figure to answer the following questions: a. What is the six-month forward rate for the Japanese yen in yen per U.S. dollar? Is the yen selling at a premium or a discount?...
-
Prior to adjustment at the end of the year, the balance in Trucks is $182,600 and the balance in Accumulated DepreciationTrucks is $75,500. Details of the subsidiary ledger are as follows: a....
-
A 60-kg woman holds a 9-kg package as she stands within an elevator which briefly accelerates upward at a rate of g /4. Determine the force R which the elevator floor exerts on her feet and the...
-
Determine the number of ways in which a software professional can choose 4 of 25 laptops to test a newly designed application.
-
Alfonso Sheen recently opened his own accounting firm, which he operates as a corporation. The name of the new entity is Alfonso Sheen, CPA. Sheen experienced the following events during the...
-
The position of a particle moving along the x-axis is given by x(t) = = 4.2 2.5t m. (Assume t is in seconds.) (a) At what time (in s) does the particle cross the origin? 1.68 S (b) What is the...
-
List three main departures that the U.C.C. made from the common law of contracts. Also explain all of these.
-
Profile Employee First Name David Last Name walliams Sex Male Date of birth 21/07/1992 Email Country Submit USA First Name must be between 3 and 25 characters Last Name must be between 3 and 25...
-
Indicate whether each of the following statements is true or false by writing T or F in t he a nswer c olumn. In all states, the crime of bribery is limited to giving or taking money or property to...
-
Indicate whether each of the following statements is true or false by writing T or F in the answer c olumn. No contract is enforceable without consideration.
-
Indicate whether each of the following statements is true or false by writing T or F in the answer c olumn. The executive branch of government sees that all enacted legislation is enforced.
-
Indicate whether each of the following statements is true or false by writing T or F in t he a nswer c olumn. The theft of goods from a vehicle in transit is known as hijacking.
-
Indicate whether each of the following statements is true or false by writing T or F in the answer c olumn. A general release allows for the discharge of a debt because it is viewed as forbearance, a...
-
You purchased shares of a mutual fund at a price of $30 per share at the beginning of the year and paid a front-end load of 2%. If the securities in which the fund invested increased in value by 15%...
-
Don Griffin worked as an accountant at a local accounting firm for five years after graduating from university. Recently, he opened his own accounting practice, which he operates as a corporation....
-
Baseball is played at a fairly leisurely pacein fact, sometimes too slow for some sports fans. What contributes to the length of a major league baseball game? The file BaseballTimes contains...
-
Table 3.4 on page 174 shows the number of points scored and penalty minutes for 24 ice hockey players on the Ottawa Senators NHL team for the 20092010 season. The data are also stored in...
-
The situation described in Exercise 4.94 Using your statistics class as a sample to see if there is evidence of a difference between male and female students in how many hours are spent watching...
-
Can the displacement of a persons trip be zero, yet the distance involved in the trip is nonzero? How about the reverse situation? Explain.
-
An object traveling at a constant velocity vo experiences a constant acceleration in the same direction for a period of time t. Then an acceleration of equal magnitude is experienced in the opposite...
-
You are told that a person has walked 750 m. What can you safely say about the persons final position relative to the starting point?
Study smarter with the SolutionInn App