The quarterly sales () on five years, where denotes time, of a product are given in...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The quarterly sales (₂) on five years, where denotes time, of a product are given in the following table: Year 1 2 Quarter y 1 2 3 4 I 2 3 4 I 2 3 4 1 2 3 4 1 2 31 42 HEBERRECHNER 21 13 33 45 19 15 36 52 15 37 52 22 24 40 3 50 4 23 Assume that the model that fits the data is given by equation y, = Bo + fit + f₂Q₂ + B₂Q₂ + B₂Q4+er where .. O.. and are the appropriately defined dummy variables for quarters 2, 3 and 4. Statistical softwares may give similar results, but here only use excel. (3.1) Write down the definitions of the dummy variables Q. Os and 04. (3.2) Plot y against for = 1.2..... 20. Use Excel. (3.3) What type of seasonal variation appears to exist? Explain your answer. (3.4) Fit model (E), then write down the prediction model. Use Excel. (3.5) Use the results in part (3.4) to calculate fe, and its 95% prediction interval. [6] [3] [8] [9] [30] The quarterly sales (₂) on five years, where denotes time, of a product are given in the following table: Year 1 2 Quarter y 1 2 3 4 I 2 3 4 I 2 3 4 1 2 3 4 1 2 31 42 HEBERRECHNER 21 13 33 45 19 15 36 52 15 37 52 22 24 40 3 50 4 23 Assume that the model that fits the data is given by equation y, = Bo + fit + f₂Q₂ + B₂Q₂ + B₂Q4+er where .. O.. and are the appropriately defined dummy variables for quarters 2, 3 and 4. Statistical softwares may give similar results, but here only use excel. (3.1) Write down the definitions of the dummy variables Q. Os and 04. (3.2) Plot y against for = 1.2..... 20. Use Excel. (3.3) What type of seasonal variation appears to exist? Explain your answer. (3.4) Fit model (E), then write down the prediction model. Use Excel. (3.5) Use the results in part (3.4) to calculate fe, and its 95% prediction interval. [6] [3] [8] [9] [30]
Expert Answer:
Answer rating: 100% (QA)
Solution 31 Definition of dummy variable In Econometrics we use a d... View the full answer
Related Book For
Discovering Advanced Algebra An Investigative Approach
ISBN: 978-1559539845
1st edition
Authors: Jerald Murdock, Ellen Kamischke, Eric Kamischke
Posted Date:
Students also viewed these chemistry questions
-
Draw the enolate ion that is formed when each of the following compounds is treated with sodium ethoxide. In each case, draw all resonance structures of the enolate ion, and predict whether a...
-
Draw the intermediate carbocation that is formed when each of the following compounds is treated with HBr: a. b. c. d.
-
Draw the cyclic hemiacetal that is formed when each of the following bifunctional compounds is treated with aqueous acid: (a) (b) (c) (d) H.
-
Explain whether each of the following events represents (i) a shi of the supply curve or (ii) a movement along the supply curve. a. More homeowners put their houses up for sale during a real estate...
-
The flight time of a plane flight from Denver to New York City is has an average flight time of 3 hours and 16 minutes, and standard deviation is 30 minutes. a. Give a bound on the probability that...
-
What two broad areas of the firms management does the operating return on assets assess?
-
Suppose that in the preceding exercise the first measurement is recorded incorrectly as 16.0 instead of 14.5. Show that, even though the mean of the sample increases to \(\bar{x}=14.7\), the null...
-
Following are two years of income statements and balance sheets for the Munich Exports Corporation. A. Calculate the cash build, cash burn, and net cash burn or build for Munich Exports in 2010. B....
-
Does your organization utilize self-service portals? How do you use self-service portals? If you do not have experience using self-service portals, which portals would you recommend for your...
-
A wine manufacturer can source its grapes from two vineyards: vineyard A and vineyard B. Grapes from vineyard A costs $5 per ton to process, and grapes from vineyard B costs $10 per ton to process....
-
Solve for all forces simultaneously using matrices. Calculate the forces at all pin locations and the grip force at the jaws. Please show the process, I did not add dimensions because I only want to...
-
Bhattia Inc. has credit terms of 2/15, net 60. Based on experience, 70% of all customers will take the discount. Given this information, calculate average collection period.
-
The radius of each curve is 25m and the coaster is traveling at 15m/s (34mph)? a. How much force at the top of the loop would a 65kg (140 lbs) rider feel? b. Explain why you would not want to ride...
-
How do i determine the value of an account if the initial investment is $8000 compounded monthly at 6% after 10 year
-
What type of things might be discussed when a client has an initial consultation with a Financial Planner? Explain.
-
Units produced and sold Total revenues and costs Sales revenue Direct materials costs Direct labor costs Variable manufacturing overhead Fixed manufacturing overhead Variable marketing and...
-
Why can wastewater treatment requirements in Hawaii be less stringent than those in most locations on the U.S. mainland?
-
This table shows the normal monthly precipitation in inches for Pittsburgh, Pennsylvania, and Portland, Oregon. a. Display the data in two box plots on the same axis. b. Give the five-number summary...
-
Graph A shows a swimmer's speed as a function of time. Graph B shows the swimmer's oxygen consumption as a function of her speed. Time is measured in seconds, speed in meters per second, and oxygen...
-
Return to the expanded table after Example B on page 713. a. Fill in the missing probability in the "exactly" row. b. Find the two missing probabilities in the "at most" row. For example, to find the...
-
The following data is available for an engine working on ideal Otto cycle Temperature at the beginning of compression \(=50^{\circ} \mathrm{C}\). Temperature at the end of compressor \(=373^{\circ}...
-
A single cylinder, four-stroke cycle oil engine works on diesel cycle. The following readings were taken when the engine was running at full load : Calculate (a) FP of engine, (b) mechanical...
-
A six-cylinder, four-stroke petrol engine develops \(40 \mathrm{~kW}\) when running at \(3000 \mathrm{rpm}\). The volumetric efficiency at NTP is \(85 \%\). Indicated thermal efficiency is \(25 \%\)....
Study smarter with the SolutionInn App