Using simple moving averages and the following time series data, respond to each of the items. Period Demand 1 104 2 132 3 143 4 137 5 146 6 150 7 101 8 126 9 116 10 115 Click here for the Excel Data File b. Compute all possible forecasts using a three-period simple moving average model. (Round your answers to 2 decimal places.) c. Compute the MAD. (Round your answer to 2 decimal places.) d. What is the forecast demand for period 11?

Using simple moving averages and the following time series data, respond to each of the items. Period Demand 1 104 2 132 3 143 4 137 5 146 6 150 7 101 8 126 9 116 10 115 Click here for the Excel Data File b. Compute all possible forecasts using a three-period simple moving average model. (Round your answers to 2 decimal places.) c. Compute the MAD. (Round your answer to 2 decimal places.) d. What is the forecast demand for period 11?

Functions and Change: A Modeling Approach to College Algebra (MindTap Course List)

6th Edition

ISBN:9781337111348

Author:Bruce Crauder, Benny Evans, Alan Noell

Publisher:Bruce Crauder, Benny Evans, Alan Noell

Chapter4: Exponential Functions

Section4.4: Modeling Nearly Exponential Data

Problem 3E: Special Rounding Instructions For this exercise set, round all regression parameters to three...

See similar textbooks

Similar questions

Special Rounding Instructions For this exercise set, round all regression parameters to three decimal places, but round all other answers to two decimal places unless otherwise indicated. First Down The following table shows the probability P, as a percentage, of a college football team converting on fourth down when not goal to go versus the distance D, in yards, to the first down maker. 28 D = distance, in yards P = probability 1 70 2 60 3 53 4 46 5 41 6 37 7 34 8 32 a.Use exponential regression to model the data. b.Plot the data along with the exponential model. c.What probability does the model give of gaining a first down for fourth down and 10yards to go? Note: the actual probability is 28.
Using excel. For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84, and 83. a. Construct a time series plot. What type of pattern exists in the data? b. Compare the three-month moving average approach with the exponential smoothing approach for α=\alpha =α= .2. Which provides more accurate forecasts using MSE as the measure of forecast accuracy? c. What is the forecast for next month?
Using the time series data in the table, respond to the following items. Period Sales 1 $ 615 2 678 3 761 4 710 5 784 6 801 7 852 8 698 9 1,193 10 1,115 11 1,231 12 1,259 13 1,495 14 1,229 15 1,652 16 1,337 17 1,673 18 1,613 d-1. Compute all possible forecasts using a trend forecasting model using simple linear regression? (Round your answers to 3 decimal places.) Period Sales Predicted Sales Absolute Error 1 615 2 678 3 761 4 710 5 784 6 801 7 852 8 698 9 1,193 10 1,115 11 1,231 12 1,259 13 1,495 14 1,229 15 1,652 16 1,337 17 1,673 18 1,613 d-2. What is the MAD? (Round your answer to 3 decimal places.) d-3. What is the trend equation based on the regression analysis? (Round your answers to 3 decimal places.) Sales = __________ + _______________ time…
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?
Refer to the gasoline sales time series data in the given table. Compute four-week and five-week moving averages for the time series. Round your answers to two decimal places. Compute the MSE for the four-week and five-week moving average forecasts. Round your intermediate calculations and final answers to two decimal places. What appears to be the best number of weeks of past data (three, four, or five) to use in the moving average computation? Recall that MSE for the three-week moving average is 12.89.
Consider the following time series data: Week 1 2 3 4 5 6 Value 18 13 16 11 17 14 Using the naïve method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy: a. Mean absolute error b. Mean squared error c. Mean absolute percentage error d. What is the forecast for week 7?
#1Consider the following time series data.Week 1 2 3 4 5 6 Value 18 13 16 11 17 14 a. What is the forecast for week 7 using the 6 period moving average method? Round to nearest hundredth. b. What is the MAE using the 6 period moving average method? c. What is the MSE using the 6 period moving average method?
After its move in 1990 to La Junta, Colorado, and its new initiatives, the DeBourgh Manufacturing Company began an upward climb of record sales. Suppose the figures shown here are the DeBourgh monthly sales figures from January 2001 through December 2009 (in $1,000s). a) Produce a time series plot. Are there any trends evident in the data? Does DeBourgh have a seasonal component to its sales? b) Deseasonalize the data using Multiplicative model with a 0.5 weighted moving average. Produce a time series plot of the deseasonalized data and add a trendline. c) Forecast the sales from January to December of the year 2010. d) Include a discussion of the general direction of sales and any seasonal tendencies that might be occurrinG Month 2001 2002 2003 2004 2005 2006 2007 2008 2009 January 139.7 165.1 177.8 228.6 266.7 431.8 381 431.8 495.3 February 114.3 177.8 203.2 254 317.5 457.2 406.4 444.5 533.4 March 101.6 177.8 228.6 266.7 368.3 457.2 431.8 495.3 635 April 152.4 203.2…
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.
Below you are given the first five values of a quarterly time series. The multiplicative model is appropriate and a four-quarter moving average will be used. Year Quarter Time Series Value Yt 1 1 36 2 24 3 16 2 4 20 1 44 An estimate of the combined trend-cycle component (T2Ct) for Quarter 3 of Year 1 (used for estimating the de-trended values), when a four-quarter moving average is used, is a. 24. b. 26. c. 28. d. 25.
Match the following definitions to their appropriate terms: Group of answer choices based on an anlaysis of historical data concerning one or more time serie based on the assumption that the variable we are forecasting has a cause-effect relationship with one or more other variable a set of observations measured at successive points in time or over successive periods of time generally involve the use of expert judgment to develop forecasts A. Quantitative B. Qualitative C. time series methods D. Casual method
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…