CoursHeroTranscribedText: Date Rio Tinto Share Value Iron Ore Prices US GDP ($USD Billion) GFC Carbon Tax 3/1/1988 6/1/1988 9/1/1988 12/1/1988 3/1/1989 6/1/1989 9/1/1989 12/1/1989 3/1/1990 6/1/1990 9/1/1990 12/1/1990 3/1/1991 6/1/1991 9/1/1991 12/1/1991 3/1/1992 6/1/1992 9/1/1992 12/1/1992 3/1/1993 6/1/1993 9/1/1993 12/1/1993 3/1/1994 6/1/1994 9/1/1994 12/1/1994 3/1/1995 6/1/1995 9/1/1995 12/1/1995 3/1/1996 6/1/1996 9/1/1996 12/1/1996 3/1/1997 6/1/1997 9/1/1997 12/1/1997 3/1/1998 4.57 6.38 6.88 6.50 6.76 6.85 8.68 8.74 9.42 9.28 9.02 7.59 8.82 10.46 10.84 9.96 10.68 11.33 10.17 9.72 10.26 10.30 11.71 13.53 13.83 13.80 15.12 14.40 13.56 15.11 16.56 16.11 15.32 15.91 14.85 15.78 14.91 16.62 16.23 13.49 15.38 10.51 10.51 10.51 10.51 12.03 12.03 12.03 12.03 14.05 14.05 14.05 14.05 15.03 15.03 15.03 15.03 14.31 14.31 14.31 14.31 12.58 12.58 12.58 12.58 11.45 11.45 11.45 11.45 12.27 12.27 12.27 12.27 12.97 12.97 12.97 12.97 13.04 13.04 13.04 13.04 13.41 1272.65 1301.93 1324.88 1353.18 1381.85 1407.10 1427.90 1440.85 1472.70 1493.68 1507.38 1505.83 1513.73 1535.90 1554.60 1569.83 1595.20 1623.08 1646.63 1674.40 1687.05 1707.40 1726.05 1758.20 1784.08 1817.45 1838.08 1869.18 1886.33 1901.23 1926.63 1949.88 1973.28 2015.38 2039.75 2071.78 2100.53 2137.98 2172.95 2197.08 2222.43 No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No 6/1/1998 9/1/1998 12/1/1998 3/1/1999 6/1/1999 9/1/1999 12/1/1999 3/1/2000 6/1/2000 9/1/2000 12/1/2000 3/1/2001 6/1/2001 9/1/2001 12/1/2001 3/1/2002 6/1/2002 9/1/2002 12/1/2002 3/1/2003 6/1/2003 9/1/2003 12/1/2003 3/1/2004 6/1/2004 9/1/2004 12/1/2004 3/1/2005 6/1/2005 9/1/2005 12/1/2005 3/1/2006 6/1/2006 9/1/2006 12/1/2006 3/1/2007 6/1/2007 9/1/2007 12/1/2007 3/1/2008 6/1/2008 9/1/2008 12/1/2008 3/1/2009 15.70 14.58 15.70 16.26 18.80 21.11 22.47 19.60 20.53 20.33 21.61 24.97 28.25 25.77 27.32 30.50 27.54 25.29 26.44 25.36 24.21 26.02 28.35 27.90 27.25 29.42 30.24 35.58 33.86 41.69 49.18 59.38 61.66 57.16 59.65 60.73 72.85 77.51 102.30 100.56 107.68 88.70 42.64 38.38 13.41 13.41 13.41 11.93 11.93 11.93 11.93 12.45 12.45 12.45 12.45 12.99 12.99 12.99 12.99 12.68 12.68 12.68 12.68 13.82 13.82 13.82 13.82 16.39 16.39 16.39 16.39 28.11 28.11 28.11 28.11 33.45 33.45 33.45 33.45 36.63 36.63 36.63 36.63 60.8 60.8 60.8 63.86 70.72 2248.68 2286.63 2331.43 2361.78 2389.25 2428.08 2481.53 2507.75 2569.58 2589.35 2618.08 2627.03 2659.60 2659.88 2675.33 2708.60 2733.70 2759.28 2775.95 2807.53 2842.68 2906.28 2954.20 2997.10 3045.35 3091.93 3140.55 3203.43 3243.53 3301.35 3345.40 3412.23 3449.95 3477.13 3516.60 3558.30 3605.58 3642.43 3671.33 3667.10 3703.25 3710.75 3637.48 3595.98 No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No Yes Yes Yes Yes Yes Yes Yes No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No 6/1/2009 9/1/2009 12/1/2009 3/1/2010 6/1/2010 9/1/2010 12/1/2010 3/1/2011 6/1/2011 9/1/2011 12/1/2011 3/1/2012 6/1/2012 9/1/2012 12/1/2012 3/1/2013 6/1/2013 9/1/2013 12/1/2013 3/1/2014 6/1/2014 9/1/2014 12/1/2014 3/1/2015 6/1/2015 9/1/2015 12/1/2015 3/1/2016 51.31 58.58 70.11 72.30 68.63 72.49 83.46 84.58 82.23 71.44 64.15 67.34 59.90 51.93 60.57 63.54 54.45 59.18 66.08 65.34 60.10 62.86 59.17 59.73 56.37 50.58 47.09 40.70 64.71 87.44 97.1 131.1 159.15 137.44 159.19 178.72 175.75 175.89 140.81 141.8 139.51 111.74 121.06 148.33 125.41 132.81 134.89 120.44 102.63 90.29 74.01 62.34 57.89 54.44 46.17 47.65 3585.10 3596.03 3641.63 3670.28 3722.15 3764.43 3807.55 3809.60 3865.23 3896.78 3946.33 3993.48 4030.48 4056.98 4074.33 4118.85 4135.35 4187.33 4249.98 4256.30 4321.40 4392.35 4423.05 4445.90 4499.58 4535.48 4555.70 4570.40 Yes Yes Yes Yes Yes Yes Yes Yes Yes No No No No No No No No No No No No No No No No No No No No No No No No No No No No No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No No No No No No No Aus GDP ($USD Billion) High Chinese Growth 177.954 178.848 180.070 182.229 185.108 187.689 189.339 190.179 190.456 190.826 190.833 190.092 189.169 188.481 188.551 189.474 190.579 192.247 194.646 197.311 199.272 200.387 201.812 204.447 207.743 210.614 212.397 213.374 214.505 216.191 218.698 221.354 223.692 225.807 227.376 229.248 232.046 235.357 238.368 240.462 242.514 Yes Yes Yes Yes Yes Yes Yes Yes No No No No No No No No No No No No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No 245.743 249.413 252.739 254.979 256.849 259.245 262.272 265.095 266.556 266.880 267.284 268.782 271.404 274.264 277.215 280.297 283.230 285.509 286.811 287.869 290.221 294.041 298.208 301.277 303.350 305.427 307.744 310.109 312.707 315.495 317.619 318.910 320.406 323.567 328.061 332.533 335.890 338.645 341.204 343.949 345.808 346.672 347.396 348.809 No No No No No No No No No No No No No No No No No No No No No No No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No No 350.781 352.887 354.617 356.503 358.796 361.031 362.932 364.884 367.648 371.607 375.899 379.276 381.956 383.930 385.526 387.182 389.146 391.799 394.869 397.736 400.059 402.105 404.191 406.577 409.190 412.342 415.896 419.560 No No No No No No No Yes Yes Yes Yes No No No No No No No No No No No No No No No No No BEA 674 Data and Business Decision Making, S2, 2016 - Assignment BEA 674 Data and Business Decision Making Tasmanian School of Business and Economics University of Tasmania Assignment Information Due: Friday 7 October2pm AEST Value: 20% Marks: 100 Overview You will define your own objective for your study using the data provided or that you collect. Your objective should be relevant to your data and have some meaning and relevance to business and related disciplines. You will select the key variable of interest and at least 3 other variables you think may be related to it, so that you may examine their relationship with the key variable. Find Partners Find other students to form groups of 2 or 3. Select Data Select to use either the: 1. Data provided on BEA674 MyLO/Content/Assessment/Assignment or 2. Collect your own data. 2.1. Find at least 20 observations on your key variable and 3+ other variables. 2.2. The data should be either for the 2.2.1. Time Series Data - same unit of analysis across time (data for Australia 1996 to 2016) 2.2.2. Cross-section Data - same time period across units of analysis (data for households in 2013) 2.2.3. Panel Data units and analysis and time both vary across observations. 2.3. Each single observation the data must be for a single unit of analysis and time (Australia 1996 or the 291st household for 2013) 3. Identify your key variable of interest, that you are mainly interested in. It will be easiest if your key variable is a continuous or discrete numerical variable rather than a qualitative variable. 4. Select at least three variables: at least one of which must be numerical and one must be categorical. Those using time series data, may create a dummy variable (0 and 1) equal to 1, for times that a certain event is occurring (eg. winter, recession, GFC). University of Tasmania - CRICOS PROVIDER CODE 00586B 1 BEA 674 Data and Business Decision Making, S2, 2016 - Assignment Note that you can combine each assessment criteria listed against the left margin of the page and do not have to address each one with a separate sentence. A. Write your introduction ( to page) 20 marks A1. A2. A3. A4. A5. A6. Clearly state the objective for your study in 1-2 sentence(s). Provide the details for who/what when your analysis of this question will cover in a single sentence. Explain why the study is of interest in 1-3 sentences. Provide the source, in brief of the data you will use in a single sentence. Provide details on what is your key variable and explanatory variables will you use, in 13 sentences. Explain why you choose those independent variables and the potential relationship of your x variables upon your y variable using any relevant theories, statements, beliefs or previous work in the literature in 2-4 sentences. B. Summarise and Chart Your Data 20 marks B1. B2. B3. B4. B5. B6. B7. Time Series: Provide the frequency you will use and any methods used to alter the frequency of your data Cross-sectional: Provide the unit of analysis, that is, what does each observation represent Provide the sample range and number of observations Provide the full source of each of your variables. If you are using data from BEA674 MyLO then the source for your data and all variables is BEA674 MyLO. Provide the measures of each of your variables. a. units of measurement (eg. $, $m, % ) b. Time Series: original, seasonally adjusted, trend/smoothed, nominal or real (if so how and what price series was used) levels, change or growth? Frequency of change or growth (eg. annual or daily?) c. Cross-sectional: did you transform or change any of the original data. Explain why you selected or changed the above measures of your variables. For your y and each of your numerical x variables provide summary statistics a. five-number summary (min, Q1, median, Q3, max) b. sample mean, standard error of the sample mean and sample standard deviation For categorical variables show the frequency distribution either a table or chart. Interpret and comment on B6, B7, C1 and C2 highlighting any thing that is relevant to your study. University of Tasmania - CRICOS PROVIDER CODE 00586B 2 BEA 674 Data and Business Decision Making, S2, 2016 - Assignment C Examine the Relationships on Your Key Variable of Your other Variables 30 marks C1. Provide charts and tables that show the relationship using techniques from BEA674 C2. For time series data provide time-series charts of your y and x variables over the sample range. for cross-sectional data provide charts or tables that show the value of your y and x variables by groups based upon one for your qualitative x variables (or values of a quantitative variable if you have no qualitative variables) C3. Interpret and comment on the above highlighting any signs that there is a relationship between your Y and X variables and the possible nature of that relationship (linear or otherwise) D Propose and Test Hypothesis (to page) 10 marks D1. Propose and test hypothesis relevant to your study. D2. Conduct and interpret E Write Conclusion (to page) 10 marks E1. Discuss your results, and make recommendations for appropriate business/policy decision making. Note that this section should not be used to simply repeat discussion on results. E2. You should also comment on 'bigger' issues related to the data provided and make suggestions for consideration of other variables and analyses which would be valuable in future research and business/policy decision making. Support your suggestions with relevant references where possible. F Appendices 0 marks G References 0 marks H Overall Structure (and F and G) 10 marks University of Tasmania - CRICOS PROVIDER CODE 00586B 3 BEA 674 Data and Business Decision Making, S2, 2016 - Assignment Marking Rubric A Introduction Total / 20 A1 /5 A2 /2 A3 /4 A4 /1 A5 /2 A6 /6 B Data Summary and Charts / 20 B1 /1 B2 /1 B3 /1 B4 /1 B5 /1 B6 /7 B7 /8 C Relationships with your key and other variables /30 C1 / 10 C2 / 10 C3 / 10 D Propose and Test Hypothesis / 10 D1 /3 D2 /7 E Conclusion / 10 E1 /6 E2 /4 F Appendices, G References , H Overall Structure Total Marks University of Tasmania - CRICOS PROVIDER CODE 00586B / 10 % / 100 4