Generate an appropriate excel chart showing yearly growth

Assignment Help Macroeconomics
Reference no: EM132078646

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

Reference no: EM132078646

Questions Cloud

Revolves around ethics and ethical decision making : Select a relevant and topical leadership issue from current news media that revolves around ethics and ethical decision making.
Showing the traded-off between public sector : Sketch a production possibilities frontier for the years 1982 and 1983, showing the traded-off between public sector
How would you define democracy : How would you define “democracy”? The founding fathers of the United States advocated for a “republic”.
Economic costs of environmental damage-for example : GDP calculations do not directly include the economic costs of environmental damage-for example
Generate an appropriate excel chart showing yearly growth : Using 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
What types of metrics should marketers analyze : What types of metrics should marketers analyze? What is the best way to track this information?
Determine the diameter of the smallest pin : Determine the diameter of the smallest pin that can be used if its working shear stress is 60 MPa.
What is the required return on the company equity : Hightower, Inc. plans to announce it will issue $2.0 million of perpetual debt and use the proceeds to repurchase common stock. The bonds will sell at par with.
Statement about effective control system : Identify a true statement about an effective control system. One way of pursuing a differentiation strategy is by.

Reviews

len2078646

8/7/2018 2:31:52 AM

The assignment will take the form of a report. Assignments must be submitted electronically via Canvas and must constitute your own work (they are not group assignments). Submission for this assignment is via Turnitin. If assignments are late then marks will be deducted at 1 mark per day. Of course, if you have encountered some trouble and have been unable to meet the deadline then please apply for Special Consideration.

len2078646

8/7/2018 2:31:46 AM

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 60 words). Note: Bullet points that simply describe the chart generated are duplicating information that is clearly visible and will not earn any marks. Your answers must be provided under the 4 sections provided in the word document and address each of the components.

Write a Review

Macroeconomics Questions & Answers

  Inflation targeting be a good policy

Why might it be difficult for the Fed to formally adopt inflation targeting?  Would inflation targeting be a good policy for the Fed in the present economic environment

  In using the taylor rule

In using the Taylor Rule as a guideline for monetary policy, what are the pros and cons of using forecasted values of inflation and output rather than observed values of these variables?

  Describe the present economic crisis situation in europe

Describe the present economic crisis situation in Europe.  Why has it been so difficult for the Europeans to find a solution to this problem?   Comment on what implications the crisis may have for the rest of the world if Europeans are not able to ag..

  Long-term federal government budget problems

Question:. Explain why there are long-term Federal government budget problems. Explain why the base-line forecast of the CBO is misleading.

  Derive and compare demand curve

Question based on Derive and compare demand curve,  Derive Ambrose's demand function for peanuts. How does it compare with Johnny's demand curve for peanuts?

  Problem based on utility function

Problem based on  Utility Function - Problem,  Answer and explain the following using a diagram which is completely labeled.

  Laffer curve : tax rate and tax revenue

Question based on Laffer Curve : Tax Rate and Tax Revenue,  Do raising tax rates necessarily raise tax revenue? What factors affect how tax revenue changes when tax rates change?

  Problem - income elasticity of demand

Problem - Income Elasticity of Demand,  Interpret the following Income Elasticities of Demand (YED) values for the following and state if the good is normal or inferior; YED= +0.5 and YED= -2.5

  Positive balance of payment

Question Positive Balance of Payment: "Things will look good for the US if we could just get to where we are consistently running a positive Balance of Payments."

  Effect of recession on the investment curve

Comment on the effect of a recession on the investment curve (only) and on the level of savings, investment, and the equilibrium real interest rate in the financial crisis that hits United States first starting in fall 2007.

  Affect of falling domestic investment on trade surplus and

How will a fall in domestic investment affect the trade surplus and net capital outflows in the domestic economy, the trade deficit and capital inflows in the rest of the world.

  Crises in the banking sector and bank run

Banking crises crisis decreases depositors' confidence in the banking system. What would be the effect of a rumor about a banking crisis on checkable deposits in such a country?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd