Consider the following time series data: Week Value 1 18 2 13 3 16 4 11...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Consider the following time series data: Week Value 1 18 2 13 3 16 4 11 5 17 1) Construct a time series plot. What type of trend exists in the data? 2) Develop the three-week moving average forecasts for this time series: 1 mt = Σ--∞ ajXt-j, where a;=, j = 1,2,3, zero else. 88 aj 3 Compute the mean squared error. Compute a forecast for week 7. 3) Develop the three-week moving average forecasts for this time series: m₁ = Σ;=-∞ ª¡Xt-j, where (a₁, a₂, a3) = (), zero else. Compute the mean squared error. Compute a forecast for week 7. 6 14 4) Use a = 0.2 to compute the exponential smoothing forecasts for the time series. Compute the mean squared error. Compute a forecast for week 7. 5) For the above data calculate BX₁, B2X, VX, V₂Xt, and V2X₁. 6) For the above data calculate Ŷ(h), and p(h). 7) Try to fit a linear regression model for the above data. What can you conclude? Consider the following time series data: Week Value 1 18 2 13 3 16 4 11 5 17 1) Construct a time series plot. What type of trend exists in the data? 2) Develop the three-week moving average forecasts for this time series: 1 mt = Σ--∞ ajXt-j, where a;=, j = 1,2,3, zero else. 88 aj 3 Compute the mean squared error. Compute a forecast for week 7. 3) Develop the three-week moving average forecasts for this time series: m₁ = Σ;=-∞ ª¡Xt-j, where (a₁, a₂, a3) = (), zero else. Compute the mean squared error. Compute a forecast for week 7. 6 14 4) Use a = 0.2 to compute the exponential smoothing forecasts for the time series. Compute the mean squared error. Compute a forecast for week 7. 5) For the above data calculate BX₁, B2X, VX, V₂Xt, and V2X₁. 6) For the above data calculate Ŷ(h), and p(h). 7) Try to fit a linear regression model for the above data. What can you conclude?
Expert Answer:
Answer rating: 100% (QA)
1 The time series plot shows a fluctuating trend with no clear increasing or decreasi... View the full answer
Related Book For
An introduction to management science quantitative approaches to decision making
ISBN: 978-1111532222
13th edition
Authors: David Anderson, Dennis Sweeney, Thomas Williams, Jeffrey Cam
Posted Date:
Students also viewed these accounting questions
-
Consider the following time series data: a. Construct a time series plot. What type of pattern exists in the data? b. Develop a three-week moving average for this time series. Compute MSE and a...
-
Consider the following time series data: a. Construct a time series plot. What type of pattern exists in the data? b. Develop a three-week moving average for this time series. Compute MSE and a...
-
Internal Company Assessment (Strategic Analysis Output) on Riise Ev converting Canada post delivery cars to electronic finding out firm strengths weakness liabilities problem constraints...
-
Conduct an online search to learn more about the marketing research industry. Develop a presentation describing the variety of jobs in the marketing research field along with the compensation for...
-
Refer to the preceding problem, E7-12. Using FIFO, answer the same questions. Data From Exercises 12 Earthtones Paint Company uses a process-cost system. Materials are added at the beginning of a...
-
Calculate the maximum power and LCOE for a parabolic collector similar to that in Example 8.1, but assume that an evacuated tube receiver is used (case E in Figure 8.18a). Example 8.1 Figure 8.18...
-
Accounting for Patents during 2007, Thompson Corporation spent $170,000 in research and development costs. As a result, a new product called the New Age Piano was patented. The patent was obtained on...
-
Whole Foods Market is the leading natural and organic foods supermarket, the first national "Certified Organic" grocer. The company incorporated in 1978, opened the first Whole Foods Market store in...
-
You have been employed as a consultant to Golf R Us, Inc. The company has been having problems with account receivables and they want to use various dunning methods to better their receivables. But...
-
Upload your java file(s) to Ecampus or Present the program to the class or demo to instructor during open lab. Complete your game that was begun in Homework 4. It should have the following...
-
Assume that you have bought BHP October 49 some time ago when the common share price was $46, the strike price of the call is $49 and each call costs you $3 (column 1). The 2nd column gives data for...
-
Analyze the key profitability ratios and identify the reason for the change in them by answering the following questions., Keep in mind the following assumptions for solving this question: The key...
-
Consider the following strong form. d'u -u+z=0 for 0
-
The time-domain specifications when the pendulum is balanced and tracking a rotary arm setpoint are: PO < 6.81% ts 1.54 s Thus, as the rotary arm goes back and forth to track the reference (while...
-
How to calculate the payback period in excel (can you provide the excel formula) year 0 1 2 3 4 5 6 7 NPV IRR B/C PB K K K K K K K K K K TR Cash flow 10,139,700,000.00 K 2,614,800,000.00 K...
-
A silver dollar is dropped from the top of a building that is 1331 feet tall. Use the position function below for free-falling objects. +vot + 50 (a) Determine the position and velocity functions for...
-
A 6-lb shell moving with a velocity ?? v0k explodes at point D into three fragments which hit the vertical wall at the points indicated. Fragments A, B, and C hit the wall 0.010 s, 0.018 s, and 0.012...
-
Assume you are given a minimization linear program that has an optimal solution. The problem is then modified by changing a greater-than-or-equal-to constraint in the problem to a...
-
An investor wants to select one of seven mutual funds for the coming year. Data showing the percentage annual return for each fund during five typical one-year periods are shown here. The assumption...
-
The L. Young & Sons Manufacturing Company produces two products, which have the following profit and resource requirement characteristics: Last months production schedule used 350 hours of labor in...
-
Find the fundamental frequency of longitudinal vibration of the tapered bar shown in Fig. 8.41, using Rayleigh's method with the mode shape \[U(x)=c_{1} \sin \frac{\pi x}{2 l}\] The mass per unit...
-
Approximate the fundamental frequency of a rectangular membrane supported along all the edges by using Rayleigh's method with \[W(x, y)=c_{1} x y(x-a)(y-b)\] \[V=\frac{P}{2}...
-
The root mean square value of a signal \(x(t), x_{\mathrm{rms}}\), is defined as \[x_{\mathrm{rms}}=\left\{\lim _{T ightarrow \infty} \frac{1}{T} \int_{0}^{T} x^{2}(t) d t ight\}^{1 / 2}\] Using this...
Study smarter with the SolutionInn App