Consider the following time series: Quarter Year 1 Year 2 Year 3 68 65 59 2....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Consider the following time series: Quarter Year 1 Year 2 Year 3 68 65 59 2. 49 41 51 3 61 63 56 4 82 85 76 (a) Choose a time series plot. (i) 100 80 60 40 20 1 2 3 4 8. Period (t) 10 11 12 (ii) 100 80 60 40 20 1 2 3 4 5 7 10 11 12 Period (t) -0- (iii) 100 80 60 40 20 ++++ 8. Period (t) 1 2 3 5 6 7 10 11 12 (iv) 100 80 60 40 20 ++++ 1 2 3 4 10 6. Period(t) 8. 11 12 Graph (iii) What type of pattern exists in the data? Is there an indication of a seasonal pattern? Horizontal pattern, with seasonality (b) Use a multiple linear regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data: Qtri = 1 if quarter 1, 0 otherwise; Qtr2 = 1 if quarter 2, 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300) Qtri + Qtr2 + Qtr3 (c) Compute the quarterly forecasts for next year. Year Quarter Ft 4 1. 4 4 4 4 2. 3. Consider the following time series: Quarter Year 1 Year 2 Year 3 68 65 59 2. 49 41 51 3 61 63 56 4 82 85 76 (a) Choose a time series plot. (i) 100 80 60 40 20 1 2 3 4 8. Period (t) 10 11 12 (ii) 100 80 60 40 20 1 2 3 4 5 7 10 11 12 Period (t) -0- (iii) 100 80 60 40 20 ++++ 8. Period (t) 1 2 3 5 6 7 10 11 12 (iv) 100 80 60 40 20 ++++ 1 2 3 4 10 6. Period(t) 8. 11 12 Graph (iii) What type of pattern exists in the data? Is there an indication of a seasonal pattern? Horizontal pattern, with seasonality (b) Use a multiple linear regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data: Qtri = 1 if quarter 1, 0 otherwise; Qtr2 = 1 if quarter 2, 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300) Qtri + Qtr2 + Qtr3 (c) Compute the quarterly forecasts for next year. Year Quarter Ft 4 1. 4 4 4 4 2. 3.
Expert 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 finance questions
-
Consider the following time series data representing quarterly sales of dishwashers at Big Boys Appliances over the past two years: The scatter plot of the data above shows seasonality with trend....
-
Consider the following time series data: a. Compute MSE using the most recent value as the forecast for the next period. What is the forecast for month 8? b. Compute MSE using the average of all the...
-
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...
-
Cherokee Company had an accounts receivable balance of $16,000 on December 31, 2013. Projected sales for the first three months of 2014 are: January $120,000 February 130,000 March 100,000 All sales...
-
Beryllium oxide is a chemical compound used in pharmaceutical applications. Beryllium oxide can only be made in one particular way, and all firms produce their version of beryllium oxide to the exact...
-
Estimate the flow law parameter A from the ice speed profile of the Worthington Glacier in Figure 8.12b. Assume the local slope of the glacier at the borehole location to be 60 m/km, and that the ice...
-
Refrigerant-134a is being transported at \(0.08 \mathrm{~kg} / \mathrm{s}\) through a Teflon tube of inside diameter \(D_{i}=20 \mathrm{~mm}\) and outside diameter \(D_{o}=25 \mathrm{~mm}\), while...
-
Patrick Company wants to raise $50 million cash but for various reasons does not want to do so in a way that results in a newly recorded liability. The firm is sufficiently solvent and profitable, so...
-
A regional electrical distributor currently has 1,000 customers who buy an average of $5,000 per year, generating a 50% margin. From experience, the company knows that 20% of its customers will not...
-
The beam shown in Figure P567 carries a repeated, reversed load of 400 N applied at section C. Compute the resulting design factor if the beam is made from SAE 1340 OQT 1300. Data in Figure P567. 12...
-
Many people who want to start a business of their own consider simply buying an existing business, explain the reasons why one should buy an existing business instead of starting a new one.
-
How does the concept of "agency" in socialization, as emphasized by sociologists like Margaret Archer and Anthony Giddens, illuminate individuals' active engagement in shaping their socialization...
-
After investigating the technology, you have recommended that your company invest in piezoelectric generators that cost $80 000.00 each. The generator converts ambient vibrations into usable power....
-
Angela owns 250 shares that currently trades at $80 each. She declares a 2-for-1 consolidation. What is the approximate value of her portfolio?
-
What factors in an evaluation of the external environment might have led P&G to pursue the Tide Cleaners initiative? What other factors should it consider as it further develops and promotes Tide...
-
Briefly discuss the nature of any company including history, main lines of business, financial performance overview and ratios (revenue growth, profit margins, current ratios), controls, risks, and...
-
Electric Car Maker Tesla makes 100,000 units of "2170 Cell" peryear in its Nevada based gigafactory for use in Model 3 Electriccar. Data concerning the unit production costs of the "2170 Cell"are as...
-
Derive Eq. (18.33) from Eq. (18.32).
-
Giovanni Food Products produces and sells frozen pizzas to public schools throughout the eastern United States. Using a very aggressive marketing strategy they have been able to increase their annual...
-
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...
-
What are the advantages of analyzing and experimenting with a model as opposed to a real object or situation?
-
(a) While the capacitor of Figure 30.4 is being charged, is the current through the wire leading to or from the capacitor zero or nonzero? Is the electric field between the plates zero or nonzero? Is...
-
Estimate the final speed \(v\) of the charged particle in Figure 30.8 in terms of the speed of propagation \(c\) of the electromagnetic wave pulse produced by the particle's acceleration. Figure 30.8...
-
(a) If Figure 30.14 shows the oscillating electric field pattern at its actual size, estimate the wavelength of the electromagnetic wave. \((b)\) If the wave is traveling at speed \(c=3 \times 10^{8}...
Study smarter with the SolutionInn App