ACC73002: Business Analytics and Big Data - Data Analyst - Report Writing - IT Assignment Help

Assignment Task:

You are hired as a data analyst to prepare a short report (1500 words) that examines the annual dividend returns for Coca-Cola shares between 2001 and 2013 using the data contained in the spreadsheet <coke>. You have also been asked to forecast the annual dividend return for 2014.
Your report must be structured as follows:
 

1. Purpose (1 marks)
In this section, the purpose of the report needs to be clearly and concisely stated.

2. Background (2 marks)
In this section, write a brief review of annual dividend returns for Coca-Cola shares.

TASK:

1. Describe and plot the data. (4 marks).
2. Calculate and explain the linear trend forecasting equation (4 marks).
3. Calculate and explain the quadratic trend forecasting equation (4 marks).
4. Calculate and explain the exponential trend forecasting equation (use LOG10 to transform the dependent variable) (4 marks).
5. Find and explain the best-fitting autoregressive model using α = 0.05 (i.e., estimate a 1-lag model, 2-lag model, and 3-lag model and select the best fitting model) (6 marks).
6. Perform a residual analysis for each model (b) to (e) and create a combined residual plot. (6 marks).
7. Examine the standard error for the estimate (SYX) and R2 for each corresponding

This IT Assignment has been solved by our IT Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics.Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.