Using relevant data provided in the excel file generate an


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.

Your answers must be provided under the 4 sections provided in the word document and address each of the following components:

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]

GDP Highlights  -

Using the relevant data provided in the excel file, generate an appropriate excel chart showing yearly growth in GDP (growth rate for each year) from 1990 to 2017.

Provide 2 bullet points summarising your observations of the GDP data in the excel file provided. Remember to pay particular attention to the most recent period - movements/changes in the various components of GDP and their contribution to the final GDP figure.

Labour Market Highlights -

Using the relevant data provided in the excel file, generate an appropriate excel chart over the entire data period provided showing the unemployment rate.

Consider the chart generated and the rest of the labour market data in the excel file; summarise the condition of the labour market in 2 bullet points.

Price Movements -

Using the relevant data provided in the excel file, generate an appropriate excel chart showing the inflation rate and the percentage change in the price of Melbourne residential property for the 1970 to 2018 period.

Which CPI category experienced the largest growth in the most recent period? Provide an assessment whether this increase in the price level for the category may be a potential problem/benefit for the economy [150 word maximum].

Attachment:- Assignment Files.rar

Request for Solution File

Ask an Expert for Answer!!
Macroeconomics: Using relevant data provided in the excel file generate an
Reference No:- TGS02872106

Expected delivery within 24 Hours