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

Consider two consumers with the following demand functions

Consider two consumers with the following demand functions for a public good: where pi is the price that i is willing to pay for quantity G. a. What is the optimal level of the public good if the marginal cost of the pub ...

Consider the ramsey growth model with utility

Consider the Ramsey growth model with utility function Assume there are no taxes. a. Derive the conditions describing a steady state. b. Solve these conditions to obtain the steady-state values of C, K, and L. c. What is ...

Policy application suppose you are in charge of grants

Policy application . Suppose you are in charge of grants from state to local government in order to reduce inequality in the amount of resources that counties have to provide certain basic services such as roads, sheriff ...

There are two senior advisors to the government a and b

There are two senior advisors to the government, A and B, both of whom agree that the poverty line is at $4,000 for a single person. However, they have different equivalence scales. Mr. A believes that the scale factor i ...

In some large cities motorists pay a fee when they bring

In some large cities, motorists pay a fee when they bring their vehicles into the busiest part of the city (congestion charge). (a) Illustrate with a diagram and explain how this charge is an example of the price system ...

What is the cost of regular unleaded fuel in your town what

What is the cost of regular unleaded fuel in your town? What are some contributing demand and supply factors to the differences in fuel prices around the country? Think of an externality in your community. Explain what t ...

Default the republic of delinquia has a nondisaster output

(Default) The Republic of Delinquia has a nondisaster output level of $100 each year. With 10% probability each year, output falls to a disaster level of $80, and the country will feel so much pain that it will default a ...

Consider an economy where individuals live for two periods

Consider an economy where individuals live for two periods only. Their utility function over consumption in periods 1 and 2 is given by U = 2 log(C 1 ) + 2 log(C 2 ), where C 1 and C 2 are period 1 and period 2 consumpti ...

As part of a marketing research committee for your

As part of a marketing research committee for your organization, you have been assigned the task of preparing a 700-word research paper about current microeconomic thought and theory. Use Principles of Microeconomics, Ch ...

End-of-the-pipe control versus pollution preventionthe

End-of-the-Pipe Control versus Pollution Prevention The marginal cost of reduction curve illustrated in Figure 4.5 assumes a particular approach to reducing pollution, often called end-of-the-pipe control. In other words ...

  • 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

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate