Suppose these data show the number of gallons of gasoline sold by a gasoline distributor in Bennington, Vermont, over the past 12 weeks.Sales (1,000sof gallons)Week1172223194235186.1772081922102011151222 (a) Compute four-week and five-week moving averages for the time series.4-WeekMovingAverageForecast5-WeekWeek Time SeriesValueMovingAverageForecast11722194231820.5 X61719.872019.519.881919.492219.4102019.2111519.6122219.2(b) Compute the MSE for the four-week moving average forecasts. (Round your answer to two decimal places.)5.19Compute the MSE for the five-week moving average forecasts. (Round your answer to two decimal places.)5.37(c) What appears to be the best number of weeks of past data (three, four, or five) to use in the moving average computation? MSE for the three-week moving average is 9.23.O Three weeks appears to be best, because the three-week moving average provides the smallest MSE.O Three weeks appears to be best, because the three-week moving average provides the largest MSE.O Four weeks appears to be best, because the four-week moving average provides the smallest MSE.O Five weeks appears to be best, because the five-week moving average provides the smallest MSE.O None appear better than the others, because they all provide the same MSE.

4 period MA = Average of previous 4 period MSE = Mean Square error

17 2 22 19 23 18 20.5 X 6. 17 19.8 7 20 19.5 19.8 8. 19 19.4 22 19.4 10 20 19.2 11 15 19.6 12 22 19.2 ) Compute the MSE for the four-week moving average forecasts. (Round your answer to two decimal places.) 5.19 Compute the MSE for the five-week moving average forecasts. (Round your answer to two decimal places.) 5.37 O What appears to be the best number of weeks of past data (three, four, or five) to use in the moving average computation? MSE for the three-wee O Three weeks appears to be best, because the three-week moving average provides the smallest MSE. Three weeks appears to be best, because the three-week moving average provides the largest MSE. Four weeks appears to be best, because the four-week moving average provides the smallest MSE. Five weeks appears to be best, because the five-week moving average provides the smallest MSE. None appear better than the others, because they all provide the same MSE.

17 2 22 19 23 18 20.5 X 6. 17 19.8 7 20 19.5 19.8 8. 19 19.4 22 19.4 10 20 19.2 11 15 19.6 12 22 19.2 ) Compute the MSE for the four-week moving average forecasts. (Round your answer to two decimal places.) 5.19 Compute the MSE for the five-week moving average forecasts. (Round your answer to two decimal places.) 5.37 O What appears to be the best number of weeks of past data (three, four, or five) to use in the moving average computation? MSE for the three-wee O Three weeks appears to be best, because the three-week moving average provides the smallest MSE. Three weeks appears to be best, because the three-week moving average provides the largest MSE. Four weeks appears to be best, because the four-week moving average provides the smallest MSE. Five weeks appears to be best, because the five-week moving average provides the smallest MSE. None appear better than the others, because they all provide the same MSE.

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

Calls to a dispatching emergency centre for the past 24 weeks are shown in the below table: a- Use a 3-weighted moving average, with weights in descending order from recent to oldestwith w1=2w2, w2=2w3b- Find the MAD and MAPE of part ac- Plot the table and give at least three observations from the plot.
Step 4 The following table summarizes the given data and the forecast values. There will not be a forecast error for the first month. Complete the columns for the forecast error and squared forecast error. Month Value Forecast Value 1 2 3 4 5 6 7 19 27 23 28 24 23 28 19 23 23 24.25 24.2 24 Forecast Error Actual - Forecast Submit Skip (you cannot come back) 27 19 = 8 0 5 -0.25 4 Total Squared Forecast Error (Actual - Forecast)² (8)² = 64 0 1.44 The MSE will be the average of the squared forecast error column. Find the average of this column, rounding the result to two decimal places. MSE =
Part 2 of 2 Construct an ogive for the data. Cumulative Frequency 20 15 10 5 0 69.5 0 109.5 0 College Faculty 149.5 0 189.5 Number of faculty 0 229.5 0 269.5 0 309.5 X ←
Please answer part a, b, c, and d
Barrow, Alaska 40 33.6 33.3 29.7 30 27.0 20 14.4 8.8 10 10 --6.9 -9.1 20 -17.2 19.3 -21.1 -23.7 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Month Data from National Climatic Data Center Record the monthly increases and decreases in the low temperature from the previous month. Monthly Increase or Decrease (from the previous month) Month February March April May June Average Daily Low Temperature (in degrees Fahrenheit)
Month 1 2 3 4 5 6 7 Value 24 13 20 12 19 23 15 Using the most recent value as the forecast for the next month, compute the following measures of forecast accuracy: a) Mean Absolute Error (MAE) b) Mean Squared Error (MSE) c) Mean Absolute Percentage Error (MAPE) d) What is the forecast for Month 8?
Please answer with explanation all subparts. I will really upvote. Thanks
Question in 1st image. Refer to data in 2nd image.
A forecasting model was used to forecast a six-month period. Here are the forests and actual demands that resulted: Table ECI Month Actual Forecast Deviation RSFEIA-FI Sum AFI MAD April May 360 345 340 335 June 320 340 Part A. Based on the calculations from the table above, Complete table Eca (below) by recording the tracking Signal for each month. Table EC2 Month Ts April May June Part b. Write a statement Stating Whether you think the model being used is giving acuptabe answers or not.