Consider the time series data in the table below (a-c all count as one problem) a. Construct a time series plot. What type of pattern exists in the data? b. Develop a three-week moving average for this time series. Compute MSE and a forecast for week 8. c. Use α = 0.2 to compute the exponential smoothing value for the time series. Compute MSE and a forecast for week 8.

Consider the time series data in the table below (a-c all count as one problem) a. Construct a time series plot. What type of pattern exists in the data? b. Develop a three-week moving average for this time series. Compute MSE and a forecast for week 8. c. Use α = 0.2 to compute the exponential smoothing value for the time series. Compute MSE and a forecast for week 8.

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

QUESTION 17 Craig interviewed several waiters and waitresses and asked them to estimate their annual income from waiting tables. He recorded the values in the Five Number Summary below, and found one outlier of $14,500. The next smallest value in the dataset was $18,000. Min: $14,500 Q1: $18,900 Med: $20,300 Q3: $21,700 Max: $25,100 Make a boxplot for these values by hand and attach your work as a pdf, jpg, or png. A suggested way to set up your graphing space is as follows: $28,000 $27,000 $26,000 $25,000 $24,000 $23,000 $22,000 $21,000 $20,000 $19,000 $18,000 $17,000 $16,000 $15,000 $14,000
Consider the following time series data. Week 1 2 3 4 S 9 Value 18 11 14 10 16 13 (a) Construct a time series plot. What type of pattern exists in the data? ◇ The data appear to follow a cyclical pattern. O The data appear to follow a trend pattern. The data appear to follow a seasonal pattern. ◇ The data appear to follow a horizontal pattern. (b) Develop the three-week moving average for this time series. (Round your answers to two decimal places.) Week Time Series Value Forecast 1 18 2 11 3 14 4 10 5 16 6 13 Compute MSE. (Round your answer to two decimal places.) MSE= What is the forecast for week 7?
The values of Alabama building contracts (in millions of dollars) for a 12-month period follow. (a) Construct a time series plot. 400 350 300 250 200+ O 1 2 3 4 Month 5 6 What type of pattern exists in the data? 7 240 340 220 260 280 310 8 9 150- 100 The data appear to follow a seasonal pattern. The data appear to follow a cyclical pattern. The data appear to follow a trend pattern. O The data appear to follow a horizontal pattern. 10 50 0 11 12 01 2 400 350 300 250 200- 150 100 50 0 0 1 2 3 4 5 34 5 6 7 8 9 10 11 12 13 Month Time Series Value (in $ millions) 240 340 (b) Compare the three-month moving average forecast with the exponential smoothing forecast using a = 0.2. (Round your answers to two decimal places.) 220 260 280 310 210 320 250 6 320 7 Month 230 220 210 320 250 320 230 220 de 8 9 10 11 12 13 r 3-Month Moving Average Forecast (in $ millions) 400 350+ 300 250 200+ 150- 100+ 50+ 0 01010101000 400 T 350 300 0 1 2 3 4 250+ 200+ 150+ 100+ α = 0.2 Forecast (in $ millions) 50…
I need some help with the following problems on excel.
Please answer part a, b, c, and d
In Table L-1, the total value of imports of Indonesian goods and services from China for the 2010-2019 period is reported on a quarterly basis. With this data you are asked to analyze it with the Trend model and Seasonal Index. Question: a. Calculate a moving average with the average period length of 4 or MA (4) [why four?] And put the results in a column. Beware of selecting the rows to place the average result. b. Calculate the moving average with the length of the average period is 2 from the data in column MA (4) and the result is given the symbol MA (2x4) and the result is placed in a column. Beware of selecting the rows to place the average result. c. Calculate the ratio to the Moving Average (Y / MA (2x4)) and place it in a new column! d. Calculate a seasonal index and interpret the results! e. Create a Deseasonalized data series and place it in a new column! f. Plot the Dessasonalized data series and read the long-term movement patterns of data! Remember that understanding of…
Section 2.1, question 9