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 . 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. 3. Method (2 marks) In this section, the data source and empirical approach used to examine annual dividend returns needs to be detailed. 4. Results (40 marks) In this section, you need to present and summarize the results from your statistical analysis. In particular, the results section must: a. Describe and plot the data. (4 marks). b. Calculate and explain the linear trend forecasting equation (4 marks). c. Calculate and explain the quadratic trend forecasting equation (4 marks). d. Calculate and explain the exponential trend forecasting equation (use LOG10 to transform the dependent variable) (4 marks). e. 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). f. Perform a residual analysis for each model (b) to (e) and create a combined residual plot. (6 marks). g. Examine the standard error for the estimate (SYX) and R2 for each corresponding model in (f). Present these results in a single table. (4 marks). h. Based on your results in (f) and (g), together with a consideration of parsimony, which model would you select for purposes of forecasting? Discuss. (4 marks). i. Using the selected model in (h), forecast the annual dividend return for 2014. (4 marks). 5 Discussion & Conclusion (5 marks) In this section, provide a brief overview of the results. Also, provide a brief overview of the strengths and limitations with the analysis (e.g., data, method, etc.)? Provide brief concluding remarks.
same
no need for financial info
AutoSave On cokol1) - Protected View - Excel Abhinav A 0 x File Hame Inst Draw Page Layout Formulas Data Review View Help O Search Share Comments PROTECTED VIEW Be caratul-files from the Internet can contain viruses. Unless you need to adit, it's safer to stay in Protected View. Enable Editing A1 Year F G H j L M N 0 0 1 4 9 16 25 36 49 81 100 121 144 169 A B D E 1 year annual dividend log(annual dividend) time time2 2 2001 0.72 -0.1427 1 3 2002 0.80 -0.0969 2 4 2003 0.88 -0.0555 3 3 5 2004 1.00 0.0000 4 6 2005 1.12 0.0492 5 5 7 2006 1.24 0.0934 6 8 2007 1.36 0.1335 7 9 2008 1.52 0.1818 8 10 2009 1.61 0.2148 9 11 2010 1.76 0.2455 10 12 2011 1.88 0.2742 11 13 2012 0.0086 12 14 2013 1.12 0.0492 13 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 data data lag 1 data lag2 data lag? Ready 1009 Type here to search o e 11.00 10/09/2020 AutoSave On cokol1) - Protected View - Excel Abhinav A 0 x File Hame Inst Draw Page Layout Formulas Data Review View Help O Search Share Comments PROTECTED VIEW Be caratul-files from the Internet can contain viruses. Unless you need to adit, it's safer to stay in Protected View. Enable Editing A1 year D E F H 1 J L M N o P Q R R S 1 year 2 2002 3 2003 4 2004 5 2005 6 2006 7 2007 8 2008 9 2009 10 2010 11 2011 12 2012 13 2013 14 15 16 17 18 19 20 21 22 23 24 25 26 B annual dividend 0,8 0.88 1 1.12 1.24 1.36 1.52 1.64 1.76 1.88 1.02 1.12 Lagi 0.72 0.8 0.88 1 1.12 1.24 1.36 1.52 1.61 1.76 1.88 1.02 27 28 29 30 31 32 33 34 35 data data lagi data lag2 data lag3 Ready 1009 Type here to search o e 11.00 10/09/2020 AutoSave On cokol1) - Protected View - Excel Abhinav A 0 x File Hame Inst Draw Page Layout Formulas Data Review View Help O Search Share Comments PROTECTED VIEW Be caratul-files from the Internet can contain viruses. Unless you need to adit, it's safer to stay in Protected View. Enable Editing A1 fo year E F H 1 J L M N o P Q R R S 1 year D lag2 0.72 0.80 0.88 1 B Jannual dividend 0.88 1.00 1.12 1.24 1.36 1.52 1.64 1.76 1.88 1.02 1.12 C lag1 0.80 0.88 1 1.12 1.24 1.36 1.52 1.64 1.76 1.88 1.02 1.12 1.24 1.36 1.52 1.61 1.76 1.88 2 2003 3 2004 4 2005 5 2006 6 2007 7 2008 8 2009 9 2010 10 2011 11 2012 12 2013 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 data data lagi data lag2 data lag3 Ready 1009 Type here to search o e 11.00 10/09/2020 AutoSave cokol1) - Protected View - Excel Abhinav A 0 x File Hame Inst Draw Page Layout Formulas Data Review View Help O Search Share Comments PROTECTED VIEW Be caratul-files from the Internet can contain viruses. Unless you need to adit, it's safer to stay in Protected View. Enable Editing A1 fo year F H 1 J L M N o P Q R R S B annual dividend 1 1 1.12 1.24 1.36 1.52 1.64 1.76 1.88 1.02 1.12 lag1 0.88 1 1.12 1.24 1.36 1.52 1.64 1.76 1.88 1.02 D lag2 0.8 0.88 1 1.12 1.24 1.36 1.92 1.64 1.76 1.88 E lag3 0.72 0.8 0.88 1 1.12 1.24 1.36 1.52 1.64 1 year 2 2004 3 2005 4 2006 5 2007 6 2008 7 2009 8 2010 9 2011 10 2012 11 2013 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 data data lag 1 data lag2 data lag3 Ready 1009 Type here to search o e 11.00 10/09/2020 AutoSave On cokol1) - Protected View - Excel Abhinav A 0 x File Hame Inst Draw Page Layout Formulas Data Review View Help O Search Share Comments PROTECTED VIEW Be caratul-files from the Internet can contain viruses. Unless you need to adit, it's safer to stay in Protected View. Enable Editing A1 Year F G H j L M N 0 0 1 4 9 16 25 36 49 81 100 121 144 169 A B D E 1 year annual dividend log(annual dividend) time time2 2 2001 0.72 -0.1427 1 3 2002 0.80 -0.0969 2 4 2003 0.88 -0.0555 3 3 5 2004 1.00 0.0000 4 6 2005 1.12 0.0492 5 5 7 2006 1.24 0.0934 6 8 2007 1.36 0.1335 7 9 2008 1.52 0.1818 8 10 2009 1.61 0.2148 9 11 2010 1.76 0.2455 10 12 2011 1.88 0.2742 11 13 2012 0.0086 12 14 2013 1.12 0.0492 13 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 data data lag 1 data lag2 data lag? Ready 1009 Type here to search o e 11.00 10/09/2020 AutoSave On cokol1) - Protected View - Excel Abhinav A 0 x File Hame Inst Draw Page Layout Formulas Data Review View Help O Search Share Comments PROTECTED VIEW Be caratul-files from the Internet can contain viruses. Unless you need to adit, it's safer to stay in Protected View. Enable Editing A1 year D E F H 1 J L M N o P Q R R S 1 year 2 2002 3 2003 4 2004 5 2005 6 2006 7 2007 8 2008 9 2009 10 2010 11 2011 12 2012 13 2013 14 15 16 17 18 19 20 21 22 23 24 25 26 B annual dividend 0,8 0.88 1 1.12 1.24 1.36 1.52 1.64 1.76 1.88 1.02 1.12 Lagi 0.72 0.8 0.88 1 1.12 1.24 1.36 1.52 1.61 1.76 1.88 1.02 27 28 29 30 31 32 33 34 35 data data lagi data lag2 data lag3 Ready 1009 Type here to search o e 11.00 10/09/2020 AutoSave On cokol1) - Protected View - Excel Abhinav A 0 x File Hame Inst Draw Page Layout Formulas Data Review View Help O Search Share Comments PROTECTED VIEW Be caratul-files from the Internet can contain viruses. Unless you need to adit, it's safer to stay in Protected View. Enable Editing A1 fo year E F H 1 J L M N o P Q R R S 1 year D lag2 0.72 0.80 0.88 1 B Jannual dividend 0.88 1.00 1.12 1.24 1.36 1.52 1.64 1.76 1.88 1.02 1.12 C lag1 0.80 0.88 1 1.12 1.24 1.36 1.52 1.64 1.76 1.88 1.02 1.12 1.24 1.36 1.52 1.61 1.76 1.88 2 2003 3 2004 4 2005 5 2006 6 2007 7 2008 8 2009 9 2010 10 2011 11 2012 12 2013 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 data data lagi data lag2 data lag3 Ready 1009 Type here to search o e 11.00 10/09/2020 AutoSave cokol1) - Protected View - Excel Abhinav A 0 x File Hame Inst Draw Page Layout Formulas Data Review View Help O Search Share Comments PROTECTED VIEW Be caratul-files from the Internet can contain viruses. Unless you need to adit, it's safer to stay in Protected View. Enable Editing A1 fo year F H 1 J L M N o P Q R R S B annual dividend 1 1 1.12 1.24 1.36 1.52 1.64 1.76 1.88 1.02 1.12 lag1 0.88 1 1.12 1.24 1.36 1.52 1.64 1.76 1.88 1.02 D lag2 0.8 0.88 1 1.12 1.24 1.36 1.92 1.64 1.76 1.88 E lag3 0.72 0.8 0.88 1 1.12 1.24 1.36 1.52 1.64 1 year 2 2004 3 2005 4 2006 5 2007 6 2008 7 2009 8 2010 9 2011 10 2012 11 2013 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 data data lag 1 data lag2 data lag3 Ready 1009 Type here to search o e 11.00 10/09/2020