Case study: In recent years Australian export and import prices have shown dramatic trends as shown by export and import price indices. Export and import price indices measure the overall change in...

 Case study: In recent years Australian export and import prices have shown dramatic trends as shown by export and import price indices. Export and import price indices measure the overall change in the prices of goods and services exported or imported respectively. The prices of all goods and services do not change at the same rate. A price index thus summarizes their movements by averaging over them. A price index assumes a value of unity, or 100, in some reference period. Table 1 presents quarterly export and import price indices for 2000 to 2015 (see, the next attached file entitled Assignment 2 ABS-Data.xlsx). Your task is to write a report (about 1500 words): (a) Convert (using Excel or manually) quarterly export and import price indices data into yearly (Hint: first add quarterly data for each year and then divide it by four because there are four quarters in a year); (b) Discuss which is the most appropriate graph to present this statistics and then present it in a graph(s); (c) Discuss emerging trends in Australian export and import prices in the last few years; (d) Explain why this trend may have occurred in recent years (Hints: for this part you need to look at Australian trade data from the Australian Bureau of Statistics (ABS) site (www.abs.gov.au) or do some research on the net as to what kind of goods and services Australia exports and imports and what has happened to their exports and imports in recent times). (e) What would be the implications of this trend for Australian business? Discuss. Note: For this question you are required to present your answer in a report form. Your written report should have a cover page with your name, student number and an abstract of your answers (4-5 lines). In the next pages, you should have an introduction (5-10 lines), main body of the report (where you discuss/answer all five questions analytically- about 2 pages) and then a conclusion of your report (10-15 lines). Finally, you should have a reference section if you have taken material or idea from any published or unpublished sources. Each question is worth 4 marks. Q2: Two short questions (10%): (2a) The following table shows the number of days workers were absent from an office in Darwin the last. (i) Calculate the mean, the median and the mode (4 marks). 0 1 1 3 0 0 2 5 0 1 1 2 0 1 1 (2b) The mid semester examination for a statistics course had a time limit of one hour and ten minutes; however, like most statistics unit it was a very easy exam. To assess how easy the exam was, the lecturer recorded the time taken by a sample of nine students who handed in their papers in less than one hour. (i) Calculate the mean, the median and the mode (4 marks). (ii) Describe what have you learnt from the statistics calculated in part