Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Econometrics Expert

Instructions (adapted from Hanke and Wichern) (Page limit is 15 pages)

Australian Bureau of Statistics (ABS) provides retail data for different groups and different states as well as the aggregate numbers. The main webpage to access the retail statistics is:

http://www.abs.gov.au/AUSSTATS/abs@.nsf/DetailsPage/8501.0Jun%202013?OpenDocument

On the ‘Downloads’ tab you will find data for different categories. Table 11“ Retail Turnover, State by Industry Subgroup, Original” contains the data you can use in this part. You can select the state and the group you wish to analyse or you can use the aggregated data.The file contains monthly retail turnover data from April, 1982 to June, 2013. You are hired as a forecasting consultant to analyse the retail data as there is a concern that Australia retail sector is bad shape:

http://www.abc.net.au/news/2013-08-05/retail-sales-flat-in-june/4865264

You, as an econometrics expert, need to analyse, generate and assess forecasts for monthly sales retail turnover for the rest of 2013.

After consulting with your peers, you decide to consider three models/methods for applicationto this dataset to generate forecasts.

Models/Methods USING SAS AND/ OR EXCEL:

A) Naive
B) Decomposition (multiplicative model)
C) A model of your choice**.

  • Perform an exploratory analysis on the entire dataset and discuss the important aspects of the data. Show all RELEVANT output (e.g. graphs, tables).
  • Choose a suitable decomposition model for model B while clearly motivating your choiceusing your answer in part (i) and any other relevant information i.e. choose between a multiplicative OR an additive model.
  • Choose a suitable model C while again clearly motivating your choice*.
  • Clearly present and discuss the trend-cycle, seasonal and error components in the in-sample data, as assessed by model B.Contrast these components between the models B and C if appropriate.
  • Choose a model form forthe trend component (one for Model B and also for model C, but only if appropriate) and clearly and properly justify your choice.
  • Discuss and compare how well, or otherwise,the models A, B (including trend as in (v)) and C fit the data in the in-sample period. Use statistical tests if appropriate.
  • Forecast the hold-out year, of monthly turnover data using Models A-C, using only the chosen in-sample period. Provide a table of these forecasts as well as a graph, together with the actual turnover for the last 12 months.
  • Assess the accuracy of each model and compare the models for forecast performance in the appropriate ways.Identify the best forecasting model and why you chose it as best.
  • Discuss why you think the ‘best’ model beat the other two models AND/OR why there was (or wasn’t) any disagreement between forecast accuracy measures.
  • Provide 95% interval forecasts for sales in the last 12 month for each model. Clearly present the method you used to obtain such interval estimates. As much as you can, discuss, interpret and compare these intervals.Are they accurate? Is one model better than the others here?
  • Choose a forecast model from A-C, motivating your choice. Then, update it with the latest available data, and then generate both point and 95% interval forecasts for the rest of 2013.Present these in an appropriate manner. Further, discuss how accurate you think these 2013 forecasts might turn out to be, with justification.
  • Prepare an executive summary outlining and summarising your analysis, providing your forecasts in a form suitable for the evening news. Use layman’s terms, since the majority of the viewers did not take the advanced forecasting course and do not understand statistical notation.
  • prepare up to a 0.5 pagestatement outlining the state of retail sector in Australia and your expectations for the rest of 2013.prepare this like a certified statement from an expert to the governor of the Reserve Bank of Australia (RBA), so it can be used next time when RBA makes a decision on interest rates.

Econometrics, Economics

  • Category:- Econometrics
  • Reference No.:- M919

Have any Question? 


Related Questions in Econometrics

Suppose that the demand for bentonite is given by q 40 -

Suppose that the demand for bentonite is given by Q = 40 - 0.5P, where Q is in tons of bentonite per day and P is the price per ton. Bentonite is produced by a monopolist at a constant marginal and average total cost of ...

Many marginal cost curves are u-shaped as a result it is

Many marginal cost curves are U-shaped. As a result, it is possible that the MC curve hits the demand or price line at two output levels. Which is the profitmaximizing output? Why?

1 contrast bertrand and cournot competition why do they

1. Contrast Bertrand and Cournot competition. Why do they reach different market equilibria? 2. What does the residual demand curve tell us about a firm's output in Cournot competition? 3. How can reaction curves be used ...

The henrys constants for ethylbenzene at different

The Henry's constants for ethylbenzene at different temperatures are given below: (a) Express Henry's constant in various forms (K H , K aw ,K" aw , and K x ) at 298 K. (b) Calculate the enthalpy of solution for ethylben ...

A certain n-channel mosfet has a channel length of 2

A certain n-channel MOSFET has a channel length of 2 microns, a gate oxide thickness of 40 nm, and a channel mobility for electrons of 600 cm2/V s. The threshold voltage is 1 V. (a) What is the transit time of the electr ...

During the last 10 years orlando florida grew rapidly with

During the last 10 years, Orlando, Florida, grew rapidly, with new jobs luring young people into the area. Despite increases in population and income growth that expanded demand for housing, the price of existing houses ...

When natural gas prices rose in the first half of 2004

When natural gas prices rose in the first half of 2004, producers considered using natural gas fields that once had been passed over because of the high costs of extracting the gas (Russell Gold, "Natural Gas Is Likely t ...

Define saving and investment data for the simple economy of

Define saving and investment. Data for the simple economy of Newt show that in 2011, saving exceeded investment and the government is running a balanced budget. What is likely to happen? What would happen if the governme ...

1 what category of value is revealed by your answer to

1. What category of value is revealed by your answer to Question 4? What valuation method does this information lend itself to? 2. Do you feel it is appropriate to make decisions about species preservation on the basis o ...

1 if each adult angler in the united states would value a

1. If each adult angler in the United States would value a 20 percent reduction in toxins at the same rate as anglers in Wisconsin, what annual value would a nationwide 20 percent reduction provide to U.S. anglers? 2. Su ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro