Perform an exploratory analysis on the entire dataset, Database Management System

Assignment Help:

Australian Bureau of Statistics (ABS) provides retail data for different groups and different states as well as the aggregate numbers. 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, 2011. You are hired as a forecasting consultant to analyse the retail data as there is a concern that Australia retail sector is getting softer.

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

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

Models/Methods:

A Naïve

B Decomposition

C A model of your choice.

(i) Perform an exploratory analysis on the entire dataset and discuss the important aspects of the data. Show all RELEVANT output (e.g. graphs, tables).

(ii) Choose a suitable decomposition model for model B while clearly motivating your choice using your answer in part (i) and any other relevant information i.e. choose between a multiplicative OR an additive model.

(iii) Choose a suitable model C while again clearly motivating your choice*.

* Bonus marks are available for more complicated or formal models that are well chosen based on (i), if parts (iv)-(xiii) are done well, to acknowledge the extra work required for such models. However, simple models are still acceptable with full marks still possible for parts (iv)-(xiii) in that case.   

You have to use at least 6 years as the in-sample period, and your hold-out sample for forecasting should have at least 12 points.

(iv) 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.

(v)  Choose a model form for the trend component (one for Model B and also for model C, but only if appropriate) and clearly and properly justify your choice.

(vi)  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.

(vii)  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.

(viii) 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.

(ix) 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?

(x) 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 2011. Present these in an appropriate manner. Further, discuss how accurate you think these 2011 forecasts might turn out to be, with justification.

(xi) 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.


Related Discussions:- Perform an exploratory analysis on the entire dataset

List the table modification commands in sql, List the table modification co...

List the table modification commands in SQL? A) Deletion B) Updates C) Insertion D) Update of a view

Explain the term high level dml, Explain the term High level DML? High...

Explain the term High level DML? High level DML A high-level or non-procedural DML permit the user to specify what data is needed without specifying how it is to be acquired.

What are the different integrity constraints in rdbms, What are the differe...

What are the different integrity constraints in RDBMS? The various integrity constraints in RDBMS are as: Primary Key: primary key is a grouping of one or more attributes

Dealing with constraints violation, If the deletion violates referential in...

If the deletion violates referential integrity constraint, then three alternatives are available: Default option: - refuse the deletion. It is the job of the DBMS to describ

Relationships, Let us first describe the term relationships. What Are Re...

Let us first describe the term relationships. What Are Relationships? A relationship can be defined as: A set of associations or connection, or A rule for communic

School portal design and development, Project Description: This is going...

Project Description: This is going to be a School portal to handle each activities in school such as, School fees payment, online registration and every other payment, course re

Define 1 nf normal form, 1 NF Normal Form The domain of attribute must...

1 NF Normal Form The domain of attribute must add only atomic (simple, indivisible) values First normal form (Minimal Form or 1NF) is a normal form need in database normalizat

What are the disadvantages of relational data, What are the disadvantages o...

What are the disadvantages of relational data ? Disadvantages • Performance - If the number of tables among that relationships to be established are large and the tables t

Create an entity relationship diagram, Cyber Transit Ltd keeps up-to-date i...

Cyber Transit Ltd keeps up-to-date information on the processing and current position of each dispatched item. Dispatched items are the main concern of the Cyber Transit product tr

Decomposition properteis, what is lossless & dependency preserving decompo...

what is lossless & dependency preserving decomposition ?

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd