Consider the following time series data. Week 1 2 34 Value 19 11 16 10 17 12 5 6 (a) Construct a time series plot. 20 20 18 20 18 18 16 16 14 12 12 10 8. 6- 8- 4- 6- 4- 6- 4- 6. 4 2 2- 2 2 2 3. 4. 6 7 0+ 2 3 4 5 6. 7. 3. 5. 1 2. 3. 5 6 Week Week Week Week What type of pattern exists in the data? The data appear to follow a horizontal pattern. O The data appear to follow a seasonal pattern. The data appear to follow a cyclical pattern. O The data appear to follow a trend pattern. (b) Develop the three-week moving average forecasts for this time series. (Round your answers to two decimal places.) Time Series Value Week Forecast 1 19 1 3 16 10 28 44 17 21.78 Jx 12 5.44 Compute MSE. (Round your answer to two decimal places.) MSE - 18.56 What is the forecast for week 7? 13

Consider the following time series data. Week 1 2 34 Value 19 11 16 10 17 12 5 6 (a) Construct a time series plot. 20 20 18 20 18 18 16 16 14 12 12 10 8. 6- 8- 4- 6- 4- 6- 4- 6. 4 2 2- 2 2 2 3. 4. 6 7 0+ 2 3 4 5 6. 7. 3. 5. 1 2. 3. 5 6 Week Week Week Week What type of pattern exists in the data? The data appear to follow a horizontal pattern. O The data appear to follow a seasonal pattern. The data appear to follow a cyclical pattern. O The data appear to follow a trend pattern. (b) Develop the three-week moving average forecasts for this time series. (Round your answers to two decimal places.) Time Series Value Week Forecast 1 19 1 3 16 10 28 44 17 21.78 Jx 12 5.44 Compute MSE. (Round your answer to two decimal places.) MSE - 18.56 What is the forecast for week 7? 13

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

#4) Commuter ridership in Athens, Greece, during the summer months is believed to be heavily tied to the number of tourists visiting the city. During the past 12 years, the data are given in the following table. Year Number of Tourists (millions) Ridership (hundreds of thousands) 1 6 11 2 11 16 3 8 16 4 10 14 5 19 28 6 18 26 7 16 21 8 20 25 9 24 45 10 18 28 11 11 18 12 19 35 a) Create a time series plot for the ridership. b) Using linear regression to see if using the year is a good predictor for the ridership. What is the regression equation? How accurate is the model? c) Using linear regression to see if using the number of tourists is a good predictor for the ridership. What is the regression equation? How accurate is the model? d) Which linear regression equation is better? What is the expected ridership if 10 million tourists visit the city next year? e) Excel File
Consider the following gasoline sales time series data. Click on the datafile logo to reference the data. Week. Sales (1000s of gallons) 1 16 2. 22 3. 18 4. 23 5. 18 6. 17 7 21 8 17 9 21 10. 21 11 14 12 23 Using a weight of 1/2 for the most recent observation, 1/3 for the second most recent observation, and third the most recent observation, 1/6 compute a three-week weighted moving average for the time series (to 2 decimals). Enter negative values as negative numbers. Week Time-Series Value Weighted MovingAverage Forecast ForecastError (Error)2 Total b.…
Consider the following gasoline sales time series data. Click on the datafile logo to reference the data. Week Sales (1000s of gallons) 1 16 2 20 3 20 4 23 5 18 6 17 8 19 9 23 10 19 11 14 12 21 a. Using a weight of 1/2 for the most recent observation, 1/3 for the second most recent observation, and 1/6 the most recent observation, compute a three-week weighted moving average for the time series (to 2 decimals). Enter negative values as negative numbers. Week Time-Series Value Weighted MovingAverage Forecast ForecastError (Error)2 1 2 3 4 5 6 7 8 9 10 11 12 Total b. Compute the MSE for the weighted moving average in part (a).MSE = Do you prefer this weighted moving average to the unweighted moving average? Remember that…
The following data set provides the total number of shipments of core major household appliances in the U.S. from 2000 to 2016 (in millions): Year Shipments (millions) 2000 38.4 2001 38.2 2002 40.8 2003 42.5 2004 46.1 2005 47.0 2006 46.7 2007 44.1 2008 39.8 2009 36.5 2010 38.2 2011 36.0 2012 35.8 2013 39.2 2014 41.5 2015 42.9 2016 44.7 a. Plot the time series. b. Fit a three-year moving average to the data and plot the results. c. Fit a five-year moving average to the data and plot the results. d. Compute a linear trend forecasting equation and plot the trend line. e. Compute a quadratic trend forecasting equation and plot the results.
The Vintage Restaurant, on Captive Island near Fort Meyers, Florida, is owned and operated by Karen Payne. The restaurant just completed its second year of operation. Below are the sales for those two years (in ten thousands of dollars). Month First Year Second Year January 57 61 February 51 75 March 58 54 April 57 56 May 68 62 June 72 71 July 60 59 August 51 75 September 68 68 October 51 50 November 71 64 December 75 58 a) Construct a time-series plot in excel. (Label axes and graph) b) Develop a six month moving average. Compute MSE and forecast the amount of sales for the next month. c) Use α = 0.2 to compute the exponential smoothing values. Compute MSE and forecast for the next month. d) Compare the result for the six month average and exponential smoothing. Which appears to provide a better…
1. Consider the following time series: a. Construct a time series plot. What type of pattern exists in the data? b. Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series.
consider the following time series data.Month 1 2 3 4 5 6 7Value 24 13 20 12 19 23 15a. compute MSe using the most recent value as the forecast for the next period. Whatis the forecast for month 8?b. compute MSe using the average of all the data available as the forecast for the nextperiod. What is the forecast for month 8?c. Which method appears to provide the better forecast?
Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13 16 11 17 14 Construct a time series plot. What type of pattern exist in the data? Develop a three-week moving average for this time series. Compute MSE and forecast for week 7. Use a = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and forecast for week 7.
Consider the following time series data Month 1 2 3 4 5 6 7 8 9 10 11 12 Value 80 82 84 83 83 84 85 84 82 83 84 83 a) Construct a time series plot in Excel. Label the axes and graph. b) Develop a three month moving average forecast. Compute MSE and a forecast for month 13. c) Develop an exponential smoothing forecast with a = 0.35. Compute MSE and a forecast for month 13.
Consider the following time series data. Month 1 2 3 4 5 6 7 Value 25 14 21 13 20 24 16 (a) Construct a time series plot. -A time series plot contains a series of 7 points connected by line segments. The horizontal axis ranges from 0 to 8 and is labeled: Month. The vertical axis ranges from 0 to 30 and is labeled: Time Series Value. The points are plotted from left to right at regular increments of 1 month starting at month 1. The points appear to vary randomly between 8 to 20 on the vertical axis. The plot reaches its maximum time series value at month 1. -A time series plot contains a series of 7 points connected by line segments. The horizontal axis ranges from 0 to 8 and is labeled: Month. The vertical axis ranges from 0 to 30 and is labeled: Time Series Value. The points are plotted from left to right at regular increments of 1 month starting at month 1. The points appear to vary randomly between 8 to 20 on the vertical axis. The plot reaches its maximum time…
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 14 17 12 18 15 (a) Construct a time series plot. A time series plot contains a series of 6 points connected by line segments. The horizontal axis ranges from 0 to 7 and is labeled: Week. The vertical axis ranges from 0 to 20 and is labeled: Time Series Value. The points are plotted from left to right in regular increments of 1 week starting at week 1. The points appear to vary randomly between 10 to 17 on the vertical axis. The plot reaches its maximum time series value at week 6. A time series plot contains a series of 6 points connected by line segments. The horizontal axis ranges from 0 to 7 and is labeled: Week. The vertical axis ranges from 0 to 20 and is labeled: Time Series Value. The points are plotted from left to right in regular increments of 1 week starting at week 1. The points appear to vary randomly between 12 to 19 on the vertical axis. The plot reaches its maximum time series value at…
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 14 17 12 18 15 (a) Construct a time series plot. A time series plot contains a series of 6 points connected by line segments. The horizontal axis ranges from 0 to 7 and is labeled: Week. The vertical axis ranges from 0 to 20 and is labeled: Time Series Value. The points are plotted from left to right in regular increments of 1 week starting at week 1. The points appear to vary randomly between 10 to 17 on the vertical axis. The plot reaches its maximum time series value at week 6. A time series plot contains a series of 6 points connected by line segments. The horizontal axis ranges from 0 to 7 and is labeled: Week. The vertical axis ranges from 0 to 20 and is labeled: Time Series Value. The points are plotted from left to right in regular increments of 1 week starting at week 1. The points appear to vary randomly between 12 to 19 on the vertical axis. The plot reaches its maximum time series value at…