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: Review the scenario provided. Then follow steps listed to include the calculations and analysis of inflation and unemployment rates of Aondona. 1. Calculate the monthly inflation rate. o Include a column with the inflation rate to the document: Aondona Consumer Price Index o What period(s) can be labeled inflation periods, and which are deflationary periods? Explain. o What do inflation and deflationary periods mean for local producers, the economy, and foreign investors? 2. Make a graph showing the inflation rates and their corresponding months o The graph should be titled and labeled. o Data is accurately represented 3. Calculate the monthly unemployment rates. o Insert a new column titled "Monthly Unemployment" to the Aondona Employment Rates document. o Provide the unemployment rate for each month? o Show the calculations (formulas) for each answer provided 4. Calculate monthly labor participation. 1. Insert a new column titled "Participation Rate" to the Aondona Employment Rates document 2. Provide the labor participation rate for each month? 3. Show the calculations (formulas) for each answer provided 5. Make a graph showing the unemployment rate for each month o The graph should be titled and labeled. o Data is accurately represented 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: Review the scenario provided. Then follow steps listed to include the calculations and analysis of inflation and unemployment rates of Aondona. 1. Calculate the monthly inflation rate. o Include a column with the inflation rate to the document: Aondona Consumer Price Index o What period(s) can be labeled inflation periods, and which are deflationary periods? Explain. o What do inflation and deflationary periods mean for local producers, the economy, and foreign investors? 2. Make a graph showing the inflation rates and their corresponding months o The graph should be titled and labeled. o Data is accurately represented 3. Calculate the monthly unemployment rates. o Insert a new column titled "Monthly Unemployment" to the Aondona Employment Rates document. o Provide the unemployment rate for each month? o Show the calculations (formulas) for each answer provided 4. Calculate monthly labor participation. 1. Insert a new column titled "Participation Rate" to the Aondona Employment Rates document 2. Provide the labor participation rate for each month? 3. Show the calculations (formulas) for each answer provided 5. Make a graph showing the unemployment rate for each month o The graph should be titled and labeled. o Data is accurately represented 6. Analyze the data in the document: Aondona Employment Rates o What are the periods of increased unemployment and employment? o 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.

6:10 # G 46: ,ill| 27% Aggregate Expenditure ECON204 - Saved File Home Insert Draw Formulas Data Review View 123 LEX O . fx A B D E G H Consumption Government Spending Investment Imports Exports 2016 Q1 32 15 12 9 Q- 2016 Q2 54 55 12 1 8 O UI AWN 2016 Q3 22 55 54 57 58 collected for two years for the country 2016 Q4 78 44 45 52 52 of Aondona. Figures 2017 Q1 58 45 15 58 87 presented in this 2017 Q2 15 27 15 25 58 able are 8 2017 Q3 45 44 14 25 25 represented in the millions. e.g. 12 is 9 2017 Q4 41 35 47 58 25 12 million 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 Sheet1 O