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

Functional dependencies, CAR SALE (Car_id, Option_type, Option_listprice, S...

CAR SALE (Car_id, Option_type, Option_listprice, Sale_date, Option_discountedprice) This relation refers to options installed in cars (e.g., cruise control) that were sold at a de

Dataware house(job scheduling strategy), Define a job scheduling strategy t...

Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pictori

Data Minnning, Can i get help with weka software

Can i get help with weka software

What is equi join, What is equi join? Equi Join - It generates all th...

What is equi join? Equi Join - It generates all the combinations of tuples from two relations which satisfy a join condition along with only equality comparison (=).

Explain growing phase of locking, Explain Growing Phase of locking Grow...

Explain Growing Phase of locking Growing Phase: In this phase the transaction can only obtain locks, but cannot release any lock. The transaction enters the growing phase as so

How relational calculus is different from relational algebra, How Relationa...

How Relational Calculus is different from Relational Algebra? What do understand by TRC queries and DRC queries?  Ans: Relational calculus contain two calculi, the tuple relati

What is meant by data-transfer rate, What is meant by data-transfer rate? ...

What is meant by data-transfer rate? The data-transfer rate is the rate at which data can be retrieved from or kept to the disk.

Queries, Find the names of all Albums that have more than 30 tracks. Result...

Find the names of all Albums that have more than 30 tracks. Result: (name: varchar(255))

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