TI have provided two "mystery" time series below. Each is a real world, quarterly time series,...

TI have provided two "mystery" time series below. Each is a real world, quarterly time series, that has been transformed in some way so that you cannot discover (easily) its true identity. Your asignment is to create a 1-year (4-quarter) forecast for each series. You can use any method or combination of methods that you feel is best.

Forecast should be submitted as a spreadsheet.

Series X
91.49754
113.0043
135.4433
152.3375
102.7495
114.6203
136.7652
161.4187
115.3307
128.6314
160.2941
181.7292
110.4326
122.5296
143.1325
172.6343
104.6544
137.3593
168.622
164.4999
113.6247
123.6196
160.6547
177.0142
115.5151
122.5374
167.7764
195.3274
120.1086
137.2762
167.5343
193.2065
130.2599
135.7238
169.8141
174.7266
111.5293
134.2628
157.5919
178.2759
129.0033
136.6669
159.8415
174.9902
104.7216
121.0746
141.6719
153.4197
103.6806
125.0076
141.2849
164.4615
121.1125
134.0084
162.7654
186.1526
132.7394
142.2245
163.9436
181.3076
125.8554
141.4387
162.7154
176.054
120.2698
133.3783
159.7422
129.9537
59.98472
80.65274
110.7216
128.639
94.55294
105.6408
116.0305
116.9819

	Series Y
1.1	4,963.6
1.2	5,003.0
1.3	5,006.3
1.4	5,016.4
2.1	5,061.0
2.2	5,123.5
2.3	5,184.6
2.4	5,249.4
3.1	5,275.9
3.2	5,363.6
3.3	5,468.9
3.4	5,534.4
4.1	5,584.2
4.2	5,651.7
4.3	5,758.3
4.4	5,829.7
5.1	5,958.9
5.2	6,018.6
5.3	6,075.4
5.4	6,227.6
6.1	6,328.1
6.2	6,382.8
6.3	6,427.6
6.4	6,523.4
7.1	6,600.5
7.2	6,554.9
7.3	6,550.6
7.4	6,477.4
8.1	6,300.5
8.2	6,278.2
8.3	6,251.3
8.4	6,271.4
9.1	6,301.6
9.2	6,399.8
9.3	6,454.5
9.4	6,477.0

Expert Solution

X	Y
91.49754	4,963.60
113.0043	5,003.00
135.4433	5,006.30
152.3375	5,016.40
102.7495	5,061.00
114.6203	5,123.50
136.7652	5,184.60
161.4187	5,249.40
115.3307	5,275.90
128.6314	5,363.60
160.2941	5,468.90
181.7292	5,534.40
110.4326	5,584.20
122.5296	5,651.70
143.1325	5,758.30
172.6343	5,829.70
104.6544	5,958.90
137.3593	6,018.60
168.622	6,075.40
164.4999	6,227.60
113.6247	6,328.10
123.6196	6,382.80
160.6547	6,427.60
177.0142	6,523.40
115.5151	6,600.50
122.5374	6,554.90
167.7764	6,550.60
195.3274	6,477.40
120.1086	6,300.50
137.2762	6,278.20
167.5343	6,251.30
193.2065	6,271.40
130.2599	6,301.60
135.7238	6,399.80
169.8141	6,454.50
174.7266	6,477.00
111.5293	6,408.23
134.2628	6,434.88
157.5919	6,443.65
178.2759	6,440.94
129.0033
136.6669
159.8415
174.9902
104.7216
121.0746
141.6719
153.4197
103.6806
125.0076
141.2849
164.4615
121.1125
134.0084
162.7654
186.1526
132.7394
142.2245
163.9436
181.3076
125.8554
141.4387
162.7154
176.054
120.2698
133.3783
159.7422
129.9537
59.98472
80.65274
110.7216
128.639
94.55294
105.6408
116.0305
116.9819
108.301535
111.7386838
113.2631547
112.5713184

The numbers highlighted in RED are the forecasted ones and calculated using a simple excel average formula.

Both the series are forecasted by using a moving average method. Each successive entry is calculated by taking the average of the last 4 quarters, in both the series.

For example: The first forecasted entry in Series X i.e. 108.30 is the average of (94.55 + 105.64 + 116.03 + 116.98) last 4 quaters. The next entry will be the average of the 4 preceding quarters that will also include the first forecast we calculated.

In a similar fashion, forecasts for Series Y are calculated.

Rahul Sunny answered 1 year ago

Quarterly billing for water usage is shown below. Assume the time series has seasonality with a...

Quarterly billing for water usage is shown below. Assume the time series has seasonality with a long term trend. Year Quarter 1 2 3 4 Winter 64 66 68 73 Spring 103 103 104 120 Summer 152 160 162 176 Fall 73 72 78 88 Forecast the next four quarters: FWinter = 81.625, FSpring = 126.375, FSummer= 175.375, FFall= 92.625 FWinter = 80.625, FSpring = 120.375, FSummer= 175.375, FFall= 90.625 FWinter = 82.625, FSpring = 120.375, FSummer= 174.375, FFall= 90.625...

Below you are given the first five values of a quarterly time series of sales. Year...

Below you are given the first five values of a quarterly time series of sales. Year Quarter Time Series Value Yt 1 1 36 2 24 3 16 4 20 2 1 44 21. Refer to data above. When a naïve method is used, what is the forecast on the sales in Quarter 2 of Year 2. a. 20 b. 44 c. 27 d. 30 22. Refer to data in Q21. When a three-quarter moving average is used, what is...

There are many applications of the Fibonacci series both in mathematics and in the real world....

There are many applications of the Fibonacci series both in mathematics and in the real world. The Fibonacci series is obtained by starting with 0 and 1, and each subsequent term in the series is obtained by adding the previous two terms. Given n in the top row of the table below, the numbers in the second row represent Fib(n), the numbers in the Fibonacci series. So Fib(0) = 0, and Fib(1) = 1. Then Fib(2)is obtained by adding Fib(0)and...

1.Perfectly competitive markets and the real world - Few markets in the real world have the...

1.Perfectly competitive markets and the real world - Few markets in the real world have the characteristics of a perfectly competitive market . Does that mean the predictions of the model of perfect competition are not very useful in predicting how markets in the real world work? Discuss 2. Market equilibrium - when Market equilibrium occurs , Quantity demanded is equal to quantity supplied , Which mean that both sellers and buyers get what they want . Does a market...

Below, you are provided with a graph that depicts how Potential GDP and Real GDP change over time.

Below, you are provided with a graph that depicts how Potential GDP and Real GDP change over time. You will-use this graph to identify peaks, troughs, expansionary periods, and recessionary periods along the business cycle. Part 1: Complete the statement below with A, B, C, or D. The economy depicted above is at a peak along the business cycle at Point _______ Part 2: Complete the statement below with A, B, C, or D. The economy depicted above is at a trough along the business...

Consider the following quarterly time series. The regression model developed for this data set that has...

Consider the following quarterly time series. The regression model developed for this data set that has seasonality and trend is as follows, yˆt = 864.08 + 87.8Qtr1t + 137.98Qtr2t + 106.16Qtr3t + 28.16t Compute the quarterly forecasts for next year based on the regression model? Quarter Year 1 Year 2 Year 3 1 923 1112 1243 2 1056 1156 1301 3 1124 1124 1254 4 992 1078 1198

plz explain the following two concept Time series Stationary and nonstationary time series

1. Find the present value of a series of quarterly payments of P950 each, the first...

1. Find the present value of a series of quarterly payments of P950 each, the first payment is due at the end of 2 years and 3 months and the last at the end of 5 years and 6 months. If the money is worth 15% compounded quarterly. 2. Find the monthly payment for 36 periods to discharge an obligation of P88000 if the money is worth 12%, m=12 and the first payment is due at the end of 1...

Part 2: Transforming data and computing descriptive statistics Create a quarterly real GDP series by dividing...

Part 2: Transforming data and computing descriptive statistics Create a quarterly real GDP series by dividing nominal GDP by the GDP deflator. Also, create a money velocity series as PY/M where P is the price level, Y is real GDP, and M is the M3 money supply measure. a. Plot the velocity of money (produce a graph similar to Figure 8.2 on page 212 of the textbook). Has velocity risen or fallen over the sample period? b. What is the...

You have just won a lottery entitling you to receive, starting today, a series of 21 quarterly payments of $25,000 each

You have just won a lottery entitling you to receive, starting today, a series of 21 quarterly payments of $25,000 each, followed, one year after this series of payments ends, by a second series of annual payments of $30,000 each forever! (The first $30,000 payment is to be received exactly one year after the last $25,000 payment is received.) If the appropriate discount rate is r = 10 percent compounded continuously, what is the present value of all these future...

Question