### Exercise 17.01 Algo (Forecast Accuracy)#### Consider the following time series data:| **Week** | 1 | 2 | 3 | 4 | 5 | 6 ||----------|---|---|---|---|---|---|| **Value** | 18 | 13 | 18 | 14 | 15 | 15 |Using the naive method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy:**a. Mean absolute error (to 1 decimal):**Input Box**b. Mean squared error (to 1 decimal):**Input Box**c. Mean absolute percentage error (to 2 decimals):**Input Box %**d. What is the forecast for week 7 (to 2 decimals)?**Input Box**Feedback Section:**This section provides feedback based on your inputs.- Current feedback: Incorrect### Explanation of Graphs/Diagrams:This exercise involves a table of time series data for six weeks with corresponding values. The objective is to compute various measures of forecast accuracy using the naive method, where the forecast for the next period is the actual value from the most recent period.Try to calculate the mean absolute error, mean squared error, mean absolute percentage error, and the forecast for the next week based on given values. For more information or to verify your answers, use the provided hints or check your work options.

"Since you have posted a question with multiple sub parts , we will provide the solution only to the…

Answered: Consider the following time series…

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

Your new store opened for business on September 1. Assuming you plan to forecast sales using a 6- month Simple Moving Average approach, what is the first month you could create a forecast? January October February April O March
Year 2005-06 2006-07 2007-08 2008-09 2009-10 2010-11 Total FTES 1585 1690 1735 1935 2021 1890 Calculate the mean, median, standard deviation, the first quartile, the third quartile and the IQR. Round to one decimal place. What additional information is needed to construct a box plot for the FTES for 2005-2006 through 2010-2011 and a box plot for the FTES for 1976-1977 through 2004-2005? Compare the IQR for the FTES for 1976–77 through 2004–2005 with the IQR for the FTES for 2005-2006 through 2010–2011. Why do you suppose the IQRs are so different?
Which month has the largest interquartile range? 2 8 4 12
The MAD for the forecast developed using a weighted 2-year moving average with weights of 0.350.35 and 0.650.65 is what?
Table 2 Department Mean SD CoefVar Min Q1 Median Q3 Max IQR Skewness Finance 6.052 3.874 64.01 1.630 3.393 4.585 7.500 22.860 4.107 2.00 HR 5.441 3.235 59.45 2.000 3.200 4.100 6.430 21.860 3.230 1.24 IT 5.880 3.887 66.10 0.530 3.250 4.630 6.8 24.980 3.550 2.18 Marketing 6.010 3.737 62.18 1.670 3.475 5.000 6.645 22.200 3.170 2.14 Training 6.095 3.719 61.02 1.500 3.330 5.000 7.640 20.000 4.310 2.00 CoefVar stands for coefficient of variation graph (1) The company has hired you to answer the following questions: Do you think that the salaries in the departments are skewed, justify your answer with proper measure from table (2).
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 8. 2 5 3 4 6 7 8 9. (a) Construct a time series plot. What type of pattern exists in the data? O The time series plot shows a linear trend and no seasonal pattern in the data. O The time series plot shows a horizontal pattern, but there is also a seasonal pattern in the data. O The time series plot shows horizontal pattern and no seasonal pattern in the data. The time series plot shows linear trend and a seasonal pattern in the data. (b) Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. (Round your numerical values to three decimal places.) x, = 1 if quarter 1, 0 otherwise; x, = 1 if quarter 2, 0 otherwise; x, = 1 if quarter 3, 0 otherwise ŷ = (c) Compute the quarterly forecasts for the next year based on the model you developed in part (b). (Round your answers to two decimal places.) quarter 1 forecast quarter 2 forecast quarter 3…
Below, we see a snippet of a dataset that consists of 128 observations and 15 variables. We present two models describing the linear relationship between the BodyFat and other variables. Density BodyFat Age Weight Height Neck Chest Abdomen Hip Thigh Knee Ankle 1 1.0708 12.3 23 154.25 85.2 94.5 59.0 37.3 21.9 2 1.0853 6.1 22 173.25 83.0 98.7 58.7 37.3 3 1.0414 87.9 99.2 59.6 38.9 4 1.0751 86.4 101.2 5 1.0340 100.0 101.9 63.2 42.2 6 1.0502 94.4 107.8 66.0 42.0 23.4 24.0 67.75 36.2 93.1 72.25 38.5 93.6 25.3 22 154.00 66.25 34.0 95.8 10.4 26 184.75 72.25 37.4 101.8 28.7 24 184.25 71.25 34.4 97.3 20.9 24 210.25 74.75 39.0 104.5 60.1 37.3 22.8 24.0 25.6 Biceps Forearm Wrist 1 32.0 27.4 17.1 2 30.5 28.9 18.2 3 28.8 25.2 16.6 32.4 29.4 18.2 5 32.2 27.7 17.7 6 35.7 30.6 18.8 Analysis of Variance Table Model 1: x$BodyFat ~ x$Neck Model 2: x$BodyFat x$Neck + xSWeight + x$Height F Pr (>F) Res. Df RSS Df Sum of Sq 1 250 13348.1 2 248 9461.4 2 3886.7 50.939 < 2.2e-16 *** --- Signif. codes: 0***…
State the Five Number Summary for the following dataset. 0.03 0.04 0.05 0.07 0.08 0.09 0.11 0.13 0.14 0.15 0.17 0.19 Min: Q1: Med: Q3: Max:
Oman Company is preparing the production plan for the month of August. The production manager gathered the following data for the last seven months. Period Sales (In Units) 6,000 January February 6,500 March 5,500 April 5,800 May 6,400 June 6,200 July 6,500 Required: A. Prepare a forecast for the month of August using each of these approaches: 1. Naïve approach 2. A three-period moving average. 3. A four-period moving average. 4. A weighted average using weights of 0.50 (most recent), 0.30 and 0.20. 5. Exponential smoothing with a smoothing constant of 0.40. (start with February, use the data in January as the forecast for February and then use exponential smoothing for successive forecasts. B. Which method do you think is more accurate? Briefly explain why you choose such method. C. Discuss some potential benefits of forecasting? How does forecasting add value to the organization.
Consider the following data:Monthly Profit of a Gym Month Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Profit ($) 5,9015,901 5,6535,653 5,1545,154 4,8774,877 5,2455,245 5,7985,798 6,9196,919 6,2346,234 5,9585,958 Step 1 of 5 : Determine the three-period moving average for the next time period. If necessary, round your answer to one decimal place.
Fit a trend line to the following data by the method of semi averages. Also draw the curve for both the original and trend values Jan. Feb. Mar. Apr. May June July Aug. Sept. Oct. Nov. Dec. 24 Month : No. of births: 25 31 27 28 26 25 20 22 21 20 19
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,000s of gallons) Week 1 2 لیا 4 in 5 6 7 8 9 10 Week 11 12 1 2 3 4 5 6 7 8 9 10 11 (a) Compute four-week and five-week moving averages for the time series. 5-Week Moving Average Forecast 12 18 22 19 24 19 16 21 19 22 20 18 15 22 Time Series Value 23 19 24 19 16 21 19 22 20 15 23 4-Week Moving Average Forecast (b) Compute the MSE for the four-week moving average forecasts. (Round your answer to two decimal places.) Compute the MSE for the five-week moving average forecasts. (Round your answer to two decimal places.)

SEE MORE QUESTIONS

Recommended textbooks for you

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

Elementary Statistics: Picturing the World (7th E…

Statistics

ISBN:

9780134683416

Author:

Ron Larson, Betsy Farber

Publisher:

PEARSON

The Basic Practice of Statistics

Statistics

ISBN:

9781319042578

Author:

David S. Moore, William I. Notz, Michael A. Fligner

Publisher:

W. H. Freeman

Introduction to the Practice of Statistics

Statistics

ISBN:

9781319013387

Author:

David S. Moore, George P. McCabe, Bruce A. Craig

Publisher:

W. H. Freeman

SEE MORE TEXTBOOKS