Consider the following time series data Month 1 2 3 4 5 6 7 8 9 10 11 12 Value 90 89 86 91 90 91 88 86 91 93 90 88 a) Construct a time series plot in Excel. Label the axes and graph. b) Develop a five month moving average forecast. Compute MSE and a forecast for month 13. c) Develop a smoothing model forecast with α = 0.35. Compute MSE and forecast for month 13 d) Which model is the better predictor? Why?

Consider the following time series data Month 1 2 3 4 5 6 7 8 9 10 11 12 Value 90 89 86 91 90 91 88 86 91 93 90 88 a) Construct a time series plot in Excel. Label the axes and graph. b) Develop a five month moving average forecast. Compute MSE and a forecast for month 13. c) Develop a smoothing model forecast with α = 0.35. Compute MSE and forecast for month 13 d) Which model is the better predictor? Why?

College Algebra

1st Edition

ISBN:9781938168383

Author:Jay Abramson

Publisher:Jay Abramson

Chapter4: Linear Functions

Section4.3: Fitting Linear Models To Data

Problem 24SE: Table 6 shows the year and the number ofpeople unemployed in a particular city for several years....

See similar textbooks

Similar questions

Table 6 shows the year and the number ofpeople unemployed in a particular city for several years. Determine whether the trend appears linear. If so, and assuming the trend continues, in what year will the number of unemployed reach 5 people?
Which of the following time series forecasting methods would not be used to forecast seasonal data?
A bank wanted to find out whether the number of loan applications received are influenced by the current loan interest rate. The manager selected 11 monthly periods for which different interest rates applied and recorded the number of loan applications received. (b) Show the data graphically in a scatter plot. What relationship is observed? SHOW SOLUTION PLEASE!
If three of the quarterly seasonal indices for a set of data are 0.7,0.7, and 0.7, then the fourth seasonal index is equal to 1.4 a) TRUE b) FALSE Submit Answer format: Text The forecast with out seasonality is modeled as: Sales = 6 *t + 236.00, where t= time in months, beginning in January 2015. Seasonality for the first three months are given in the table below. Determine a seasonalized forecast for Feb of 2016. Month Seasonal Factor January 1.9000 February 0.6262 March 0.1000 Submit Answer format: Number: Round to: 1 decimal places.
Plot the sales revenue figures and appropriate trend line on a graph and identify from this the choice of model for working out the seasonal component. Using the appropriate seasonal model, complete the calculations that are required to produce the required forecasts for quarters 1, 2, 3 and 4 of 2021. On the basis of your analysis explain the recommendation that you would make to ALAW Ltd regarding its future plans.
the data contained in the datafile named crudecost shows the U.S. refiner acquisition cost of crude oil in dollars per barrel (energy information administration website,February 3, 2014).a. construct a time series plot. What type of pattern exists in the data?
Companies are devoting time and energy to promote recycling. A major recycling company found some old documents that present the recorded amount of cell phone collected over a span of eight years. Year Cellular Telephones Collected (in millions) 2009 2.2 2010 2.6 2011 2.9 2012 3.4 2013 3.1 2014 4.2 2015 4.9 2016 5.3 Part a) Develop a time series plot with Year on the X axis and Cellular Telephones Collected on the Y axis. Part b) Does there appear to be a relationship between time and cellular telephones collected?
For the Texas Shipping Company, the monthly percentages of all shipments received on time over the past 12 months are 82, 86, 87, 89, 84, 85, 84, 86, 75, 95, 90, and 92. a. Construct a time series plot (you can include it in the work file question at the end, not here). Identify what type of pattern, if any, exists in the data? Compare the three-month moving average forecast with an exponential smoothing forecast for alpha= 0.25 and answer the following: b. MSE for 3-month moving average method c. MSE for exponential-smoothing method : d. Which method should be preferred? Answer "3-month MA" or "Exponential Smoothing": e. What is the forecast for next month using the preferred method?
Consider a species that occupies a large, but fixed, number of islands. The distribution of the species across all islands is maintained by a balance between local extinctions and local colonization events. Devise a model for the relationship between the fraction of islands occupied by the species and time. Be clear to outline the assumptions you make and be sure to describe your key predictions.
Describe the three major categories of data (time-series, cross-sectional, and panel).
Q. 2 Describe the method of Moving averages for estimating the trend in a time series
please find any data set. perform descriptive and time series analytics on the data