Reference no: EM132266208
Assignment Details and Requirements -
Assume you have been hired as an economics analyst by the government. In your role you are required to produce a state of the economy report to government ministers. This report provides them with an overview of the economy and current events that may impact the economy - to help them make policy decisions.
Use the data in the excel file provided to generate the report. Answers and charts are to be in entered into the word document provided. Follow the instructions for each section - where you are required to produce ONE chart/diagram for a section, you must only produce one - if you produce more than one chart you will receive a zero mark for that rubric requirement.
Remember that you are producing a report for ministers in government therefore your writing and expression should be professional and succinct (these are very busy people - bullet points should not be more than 50 words).
Your answers must be provided under the 5 sections provided in the word document and address each of the following components:
1. Current Events - In this section, consider a recent news-worthy event that may have a macroeconomic effect on the domestic economy.
Provide a brief summary of the event.
Explain why this event is important/significant for the domestic economy; how may it affect the domestic economy. For example, will it affect a particular sector(s), what are the implications. Will it affect any of the major macroeconomic variables? How? Why? [200-250 words]
2. GDP Highlights - Using the relevant data provided in the excel file, generate ONE appropriate excel chart showing GDP per capita from June 1981 to June 2018.
Which two consumption expenditure categories experienced the largest growth rate over the most recent quarter?
3. Labour Market Highlights - Using the unemployment data provided in the excel file, generate ONE appropriate excel chart over the entire data period provided that compares the unemployment rate for all people with the male and female unemployment rate.
Using the employment data provided in the excel file, consider the distribution of employed residents by occupation and gender, and answer each of the following in bullet points:
- Which occupation has experienced the largest percentage change (positive/negative) in employment over the most recent quarter.
- Examining the entire data period provided, which occupation category has switched in terms of gender concentration.
- Considering the entire data period provided, which occupation category has experienced the smallest difference between male and female employment.
- Over the entire data period provided, which occupation has tended to have a higher proportion of female employment relative to male employment.
4. Price Movements - Using the relevant data provided in the excel file, generate ONE appropriate excel chart comparing the inflation rate for All Items and the inflation rate for Food for the period Sep-1973 to Sep-2018.
Compare the inflation rate for the CPI categories of Recreation and Culture, Clothing & Footwear, and Housing over the Sep-1990 to Sep-2018 period - which displayed the greatest variability in the 1990s?
5. Risk Outlook - Consider the world around you, including political, economic and financial considerations. What is the largest risk you perceive to the stability and growth of the Australian economy into the future? Why? [200-250 words].
Attachment:- Assignment Files.rar