The key macroeconomic issues in any economy are unemployment and inflation. Both

The key macroeconomic issues in any economy are unemployment and inflation. Both can have a devastating effect on any economy if not controlled. Unemployment is an indication of the health of the economy. Unemployment means that there is a portion of the productive population (labor force) that is not producing and unable to earn income for consumption and/or for investment. The more unemployed workers there are, the less output the economy will be able to produce. High unemployment also means that there are fewer wages available in the hands of people to consume, which reduces the incentive or need for suppliers to produce at full capacity (lower GDP). Inflation is the general and persistent increase in the price of goods and services. High inflation or hyperinflation can lead to a loss in real wages, fall in the value of the country’s currency, and economic hardship. Deflation, on the other hand, means general low prices and is also bad as it is a disincentive for producers, including farmers, as returns would be less than previous years
Scenario
Aondona is a developing country whose primary industry is oil and gas. Due to the level of growth, the type of industries and resources of the country, employment rates have varied over the years. You have been appointed as an economic advisor to the president of this country, Dr. Isabel Ihotu. She wants to create fiscal policies for the country but they will be based on the unemployment and inflation rates of the country. You are tasked with creating a trend analysis of both macroeconomics issues(unemployment and inflation) for presentation to the president.
Assignment Instructions
Review the scenario provided. Then follow steps listed to write a paper that includes the calculations and analysis of inflation and unemployment rates of Aondona.
Download and review the data from the following documents:
Aondona Employment Rates [DOWNLOAD]
Aondona Consumer Price Index [DOWNLOAD]
Note: Make sure to open and edit data using a spreadsheet program which allows for calculations, such as Microsoft Excel or Google Sheets.
Calculate the monthly inflation rate.
Include a column with the inflation rate to the document: Aondona Consumer Price Index
What period(s) can be labeled inflation periods, and which are deflationary periods? Explain.
What do inflation and deflationary periods mean for local producers, the economy, and foreign investors?
Create a graph showing the inflation rates and their corresponding months
The graph should be titled and labeled.
Data is accurately represented
Calculate the monthly unemployment rates.
Insert a new column titled “Monthly Unemployment” to the Aondona Employment Rates document.
Provide the unemployment rate for each month?
Show the calculations (formulas) for each answer provided
Calculate monthly labor participation.
Insert a new column titled “Participation Rate” to the Aondona Employment Rates document
Provide the labor participation rate for each month?
Show the calculations (formulas) for each answer provided
Create a graph showing the unemployment rate for each month
The graph should be titled and labeled.
Data is accurately represented
Analyze the data in the document: Aondona Employment Rates [DOWNLOAD]
What are the periods of increased unemployment and employment?
The years for GDP presented in the document: Aondona Aggregate Expenditure [DOWNLOAD] and unemployment in the document: Aondona Employment Rates [DOWNLOAD] overlap. Is there a correlation between GDP and the unemployment rate for the country of Aondona? Explain.
Submit your answers and your updated Aondona Employment Rates [DOWNLOAD] and Aondona Consumer Price Index [DOWNLOAD] document