Question: 1.) Deseasonalize the data using a Multiplicative model with a 0.5 weighted moving average. Produce a time series plot of the deseasonalized data and add

SALES ($1,000s) Month 2001 2002 2003 January February 114.3 2004 2005 2006

1.) Deseasonalize the data using a Multiplicative model with a 0.5 weighted moving average. Produce a time series plot of the deseasonalized data and add a trendline. A regression output is also expected here.

SALES ($1,000s) Month 2001 2002 2003 January February 114.3 2004 2005 2006 2007 2008 2009 139.7 165.1 177.8 228.6 266.7 431.8 381 431.8 495.3 177.8 203.2 254 317.5 457.2 406.4 266.7 368.3 457.2 431.8 495.3 279.4 342.9 431.8 482.6 457.2 533.4 444.5 533.4 March 101.6 177.8 228.6 635 April 152.4 203.2 673.1 May 215.9 241.3 317.5 355.6 457.2 533.4 495.3 558.8 749.3 June 647.7 812.8 July 444.5 800.1 August 736.6 228.6 279.4 330.2 406.4 571.5 622.3 584.2 215.9 292.1 368.3 546.1 660.4 609.6 673.1 190.5 317.5 355.6 431.8 482.6 520.7 558.8 660.4 September 177.8 203.2 241.3 330.2 431.8 508 508 609.6 October 139.7 177.8 215.9 330.2 406.4 482.6 495.3 584.2 November 139.7 165.1 215.9 304.8 393.7 457.2 444.5 520.7 December 152.4 177.8 203.2 292.1 685.8 635 622.3 406.4 431.8 419.1 482.6 622.3

Step by Step Solution

★★★★★

3.38 Rating (170 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Deseasonalized Data and Trend Analysis Step 1 Deseasonalizing Multiplicative Model Applied a 12month ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Figure P-23 is a time series plot of the weekly number of Influenza A Positive cases in a region of Texas from the week of September 2, 2003, to the week of April 10, 2007. The number of cases peaks...

Refer to Exercise 19.17. Analyze the data using a computer program. Is the analysis of variance table from the output of the computer program the same as your results in Exercise 19.18? In Exercise...

The following time series plot is based on data from the article Bubble Talk Expands: Corporate Debt Is Latest Concern Turning Heads(San Luis Obispo Tribune, September 13, 2002). It shows how...

The DeBourgh Manufacturing Company was founded in 1909 as a metal-fabricating company in Minnesota by the four Berg brothers. In the 1980s, the company ran into hard times, as did the rest of the...

A firm wishes to estimate graphically the betas for two assets, A and B. It has gathered the return data shown in the following table for the market portfolio and for both assets over the last 10...

Suppose the following data are prices of market goods involved in household transportation for the years 2001 through 2009. Using 2003 as a base year, compute aggregate transportation price indexes...

Use the table of annual returns in Problem for Home Depot (HD) and Lowes (LOW) to create an Excel spreadsheet that calculates the standard deviation of annual returns for HD, LOW, and the equally...

Use the table of annual returns in Problem for Home Depot (HD) and Lowes (LOW) to create an Excel spreadsheet that calculates the correlation coefficient for HD and LOW annual returns. In problem...

A time-series plot often helps you determine the appropriate model to use. For this problem, use each of the time series presented in the following table and stored in TsModel2: a. Plot the observed...

(Two NOLs, No Temporary Differences, No Valuation Account, Entries and Income Statement) Lanier Corporation has pretax financial income (or loss) equal to taxable income (or loss) from 2003 through...

1. What is the expected dollar rate of return on euro deposits if today's exchange rate is $1.10 per euro, next year's expected exchange rate is $1.166 per euro, the dollar interest rate is 10%, and...

In each reaction box, select the best reagent and conditions from each list. 1. reagent 1 2. reagent 2 3. reagent 3 Br

Define promotion.

Write a note on transfer policy.

Discuss about training and development in India?

Explain the various techniques of training and development.

The following table shows the part - machine processing indicator matrix. Determine machine groups and part families for the data using Similarity Coefficient ( SC ) algorithm. Use a threshold value...

Use Stokes' Theorem to evaluate f(y+sin x) dx+(z+cos y) dy+rdz, where C is the rve r(t) = (sint, cost, sin 2t), t = [0, 2].

Discuss the issues a decision maker should consider when determining the significance level to use in a hypothesis test.

In each of the following, indicate what method of probability assessment would most likely be used to assess the probability. a. What is the probability that a major earthquake will occur in...

A variety of sources suggest that individuals assess their health, at least in part, by estimating their percentage of body fat. A widely accepted measure of body fat uses an underwater weighing...

A truck with a heavy load has a total mass of 7500 kg. It is climbing a 15 o incline at a steady 15 m/s when, unfortunately, the poorly secured load falls off! Immediately after losing the load, the...

The 2.0 kg wood box in FIGURE P6.56 slides down a vertical wood wall while you push on it at a 45 o angle. What magnitude of force should you apply to cause the box to slide down at a constant...

A large box of mass M is pulled across a horizontal, friction less surface by a horizontal rope with tension T. A small box of mass m sits on top of the large box. The coefficients of static and...